IBM InfoSphere DataStage v8.5 - C2090-421 Free Exam Questions

A. On the Logic Post-Loop, you specify code that runs after all input records have been processed.

B. Build stages can only be used in a job that has Runtime Column Propagation (RCP) enabled.

C. The Build stage generates a C/C++ source file that is compiled and linked outside of DataStage.

D. The Build stage can be programmed to read and write automatically or code can be written to manually read and write rows.

A. the IBM Metadata repository

B. the IBM Information Server user directory

C. the local operating system directory

D. the IBM Suite User Configuration file specified within the dsenv file

A. Unsorted

B. Hash partitioned

C. Entire partitioned

D. Sorted in ascending order

E. Key partitioned

A. Suite User role

B. DataStage super operator

C. Information Analyzer Data Administrator

D. DataStage Developer

A. They are persistent.

B. They use the same data types as the parallel framework.

C. They are indexed to improve access.

D. They are compressed to minimize storage space.

A. Aggregation results outside of a certain range need to be flagged as abnormal.

B. A global aggregation across all partitions is needed.

C. The aggregation is a custom formula for your enterprise.

D. The data hasn't been sorted or grouped.

A. Accessing log files

B. Stopping a job

C. Purging log files

D. Compiling a job

E. Setting an alias for a job

A. Filter jobs in Director Client's Repository window.

B. While selecting the top folder in the project, choose Find Dependencies.

C. Sort the jobs by date in the Repository window.

D. Use the Advanced Find feature contained in the Designer interface.

A. Job Stage Column tab properties entered using "Load" feature

B. Web Service Function Definitions

C. Web Services WSDL Definitions

D. Orchestrate Schema Definitions

E. XML Table Definitions

A. Copy

B. Edit

C. Deleted

D. Remove Duplicates

E. Final

A. Use Web Services Transformer stage.

B. Call a Web Service using a DSRoutine inside the Parallel Transformer stage.

C. Use Web Services Client stage as a lookup.

D. Use WISD Input stage.

A. RCP is by default available for all DataStage Projects.

B. Use the Info Server web console to enable RCP

C. Use the DataStage Administrator to enable RCP for the project.

D. Set the APT_ENABLE_RCP environment variable to TRUE.

E. Use RCP definition wizard to initialize RCP for project use.

A. The background for the Description Annotation stage can be changed for each unique stage.

B. The full job description can be identified within the Description Annotation stage.

C. The Description Annotation stage can be added several times at different locations to identify business logic.

D. The Description Annotation stage contains both the short and full descriptions for the job.

A. An annotation can be drawn around one of more stages.

B. The Short job description field displays on log summary lines within Director client.

C. The Full job description field is only visible within the Designer Client.

D. The Short job description field will appears in job log when $APT_PM_SHOW_PIDS is set.

A. An update that replaces the existing column value if a specified condition is satisfied.

B. An update the retains the existing column value in an historical row and creates a new row with the new value.

C. An update that retains the existing column value in a list and adds the new value to the list.

D. An update that overwrites the existing column value.