PrepAway - Latest Free Exam Questions & Answers

Which two job design configuration actions would you consider to effectively use RCP?

Your job is using the DB2 Enterprise stage as a target. In this job you are inserting data into a
single existing table on a remote database. You are using Run-Time Column Propagation (RCP)
on all of the links.
Which two job design configuration actions would you consider to effectively use RCP? (Select
two)

PrepAway - Latest Free Exam Questions & Answers

A.
In the DB2 Enterprise stage use Connection properties to manage column mappings.

B.
In the DB2 Enterprise stage set the option named “Silently Drop Columns Not in Table” to
“True”.

C.
Use a Modify stage prior to the DB2 Enterprise stage in order to drop the columns not found in
the table.

D.
Use DB2 partitioning properties on the input link to the DB2 Enterprise stage to control column
layout in partitions.

Explanation:


Leave a Reply