Summer Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Note! Following P2090-045 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

Verified By IT Certified Experts

CertsTopics.com Certified Safe Files

Up-To-Date Exam Study Material

99.5% High Success Pass Rate

100% Accurate Answers

Instant Downloads

Exam Questions And Answers PDF

Try Demo Before You Buy

Certification Exams with Helpful Questions And Answers

IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1 Questions and Answers

Question 1

Where are Table Definitions stored?

Options:

A.

Information Server metadata repository

B.

In the file system as a binary file

C.

In the file system as a csv file

D.

None of the above

Buy Now
Question 2

A DataStage job can be executed from_______________

Options:

A.

DataStage Administrator client only

B.

DataStage Administrator or Director client

C.

DataStage Director client only

D.

DataStage Designer or Director client.

Question 3

Consider a Parallel Job including a Join Stage with HASH partitioning algorithm followed by an Aggregator stage. Which of the following statements about the Aggregator stage partition algorithm is correct?about the Aggregator stage? partition algorithm is correct?

Options:

A.

If the Aggregator groups on the same key column(s) as Join, SAME ensures groups of rows stays together

B.

If the Aggregator groups on different key column(s) from Join, SAME ensures groups of rows stay together

C.

If the Aggregator groups on the same key column(s) as Join, repartitioning must be done in order to have correct results

D.

ROUND ROBIN ensures correct results