Online Access Free 000-N45 Practice Test

The ODBC Connector Stage can be used to connect to __________.

• A.DB2 database
• B.Oracle database
• C.Teradata database
• D.All of the above

Which of the following CANNOT be defined in the DataStage configuration file?

• A.A named pool including only part (some) of the nodes
• B.Degree of parallelism
• C.Scratch disk dedicated for sorting
• D.Compilation options for DataStage jobs

Which type of Join would you select for the Join Stage to output unmatched records from both input data sources?

• A.Right outer join
• B.Full outer join
• C.Inner join
• D.Left outer join

Which of the following stages is NOT a file data access stage?

• A.Transformer Stage
• B.Dataset Stage
• C.Sequential File Stage
• D.FileSet Stage

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

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