Free IBM P2090-046 Exam Dumps Questions & Answers


Exam Code/Number:	P2090-046Join the discussion
Exam Name:	IBM InfoSphere Business Information Exchange Technical Mastery Test v1
Certification:	IBM
Free Question Number:	60
Publish Date:	Jul 21, 2026
# of views:	2010
Rating 100%

Page: 1 / 12
Total 60 questions

Question 1

Which of the following statements about the Lookup Stage is correct?

A.It is a Real-Time Stage
B.It can have only one input link defined
C.The default partition method for Lookup is Hash
D.It combines data horizontally

Question 2

Which description below about the Sort Stage is invalid?

A.It has a property to create a Key Change Column
B.Sort Stage uses temporary disk space while performing sort
C.All the incoming records must have different values for sorting key
D.Sort can be executed in sequential mode or parallel mode

Question 3

You are processing groups of rows in a Transformer. The first row in each group contains "1" in the Flag column and "0" in the remaining rows of the group. At the end of each group you want to sum and output the QTY column values. Which three techniques will enable you to retrieve the sum of the last group? (Choose three.)

A.Output a running total for each group for each row. Follow the Transformer stage by an Aggregator stage. Take the MAX of the QTY column for each group.
B.Output the sum that you generated each time you process a row for which the LastRow() function returns True.
C.Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column.
D.Within each group sort the Flag column in ascending order. Output the sum each time you process the row with a "1" in the Flag column.
E.Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column. Use the LastRow() function to determine when the last group is done.

Question 4

In DataStage Sequential File Stage, how is a NULL value represented?

A.A -1 for an integer field and an empty string for a VARCHAR field
B.By a space character
C.By a 'NULL' string
D.As defined by the Developer in the extended properties of the field

Question 5

What is a descriptor file of a Dataset created by the Dataset Stage?

A.Contains the actual data in text format
B.Contains the length of the data files
C.Contains metadata, data location, but not the data itself
D.Contains the actual data in binary format