Free IBM A2090-303 Exam Dumps Questions & Answers

Which step is required to change from a normal lookup to a sparse lookup in an ODBC Connector stage?

• A.  Sort the data on the reference link.
• B.  Change the lookup option in the stage properties to "Sparse".
• C.  Replace columns at the beginning of a SELECT statement with a wildcard asterisk (*).
• D.  Change the partitioning to hash.

Which statement is true about table definitions created in DataStage Designer?

• A.  By default, table definitions created in DataStage Designer are visible to other Information Server products.
• B.  Table definitions created in DataStage Designer are local to DataStage and cannot be shared with other Information Server products.
• C.  Table definitions created in DataStage Designer are not by default available to other Information Server products, but they can be shared with other Information Server products.
• D.  When a table definition is created in one DataStage project, it is automatically available in other DataStage projects, but not outside of DataStage.

Which two pieces of information are required to be specified for the input link on a Netezza Connector stage? (Choose two.)

• A.  Server name
• B.  Error log directory
• C.  Buffering settings
• D.  Table definitions
• E.  Partitioning

In a Transformer, which two mappings can be handled by default type conversions. (Choose two.)

• A.  String input column mapped to integer output column.
• B.  Integer input column mapped to string output column.
• C.  String input column mapped to a date output column.
• D.  Date input column mapped to a string output column.
• E.  Integer input column mapped to raw output column.

Identify two restructure stages that allow you to create or organize vectors in the output link results? (Choose two.)

• A.  Split Vector
• B.  Split Subrecord
• C.  Column Import
• D.  Make Subrecord
• E.  Merge records