| Exam Code/Number: | 000-418Join the discussion |
| Exam Name: | IBM Websphere Datastage V.8.0 |
| Certification: | IBM |
| Question Number: | 132 |
| Publish Date: | Jul 11, 2026 |
|
Rating
100%
|
|
Which three statements are true about Transformer stage variables? (Choose three.)
Click the Exhibit button.
A parallel job is designed to Join data from two existing persisted data sets that were created in sort order using the join keys. You have optimized the job to leverage the existing sort order instead of resorting. Using the job score fragment shown in the exhibit for this job, how would you verify that this job is optimizing the sort operation?
Your job design calls for using a target ODBC connector stage. The target database is found on a remote server. The target table you are writing into contains a single column primary key. What is the one required property for the Connection properties?
You have a nullable input column that can be mapped to a non-nullable output column.
Which three NULL handling techniques can be used in the Transformer stage for that column? (Choose three.)
You are tasked with determining the cause of a job that fails to scale beyond 3 nodes. Based on the job design, you suspect that the problem is related to highly un-even data distribution across partitions. Which two product features would help you confirm this hypothesis? (Choose two.)
