Assume you have before and after data sets and want to identify and process all of the changes between the two data sets. Assuming data is properly partitioned and sorted, which of the following should be used?
Exam C2090-424 - admin post to:2017-07-20 read more

In the Masking Policy Editor in the Data Masking stage of your job, you have specified for a column containing credit card numbers the Random Replacement masking policy. For the Copy option you have specified "(1,2)(3,4)". What changes will be made to a credit card number, such as 6327664369, to mask it?
Exam C2090-424 - admin post to:2017-07-20 read more

What is the primary advantage of creating data rules within Information Analyzer as opposed to creating them within the Data Rules stage?
Exam C2090-424 - admin post to:2017-07-20 read more

Which stages will require a schema file when runtime column propagation (RCP) is enabled? (Choose two.)
Exam C2090-424 - admin post to:2017-07-20 read more

Which of the following actions are available when editing a message handler?
Exam C2090-424 - admin post to:2017-07-20 read more

The Lookup stage is one of three stages that join records based on the values of key columns. What are the other stages? (Choose two.)
Exam C2090-424 - admin post to:2017-07-20 read more

Which type of data can be extracted using the Unstructured Data stage?
Exam C2090-424 - admin post to:2017-07-20 read more

Which of the following is TRUE when using a data set created with a 4 node config file?
Exam C2090-424 - admin post to:2017-07-20 read more

Which statement about restartable sequence jobs is TRUE?
Exam C2090-424 - admin post to:2017-07-20 read more

Which of the following is NOT TRUE about the DataStage job score?
Exam C2090-424 - admin post to:2017-07-20 read more

Given this configuration file: Which of the following describes the resulting behavior for a job consisting of Row Generator -> data set?
Exam C2090-424 - admin post to:2017-07-20 read more

Given this score: It runs 3 processes on 2 nodes. How does the job run?
Exam C2090-424 - admin post to:2017-07-20 read more

Which one of the following is an implicit data type conversion?
Exam C2090-424 - admin post to:2017-07-20 read more

Which of the following are valid stage options for a parallel DataStage job which uses a configuration file with multiple nodes and a File Connector as a source running in parallel mode? (Choose two.)
Exam C2090-424 - admin post to:2017-07-20 read more

Which statement about the ISD input stage is NOT TRUE?
Exam C2090-424 - admin post to:2017-07-20 read more

In order to collect operational metadata, you must do which of the following?
Exam C2090-424 - admin post to:2017-07-20 read more

Which statement is TRUE about Balanced Optimization?
Exam C2090-424 - admin post to:2017-07-20 read more

To run multiple copies of the same job within Director, which of the following must be supplied?
Exam C2090-424 - admin post to:2017-07-20 read more

Which statement about looping in sequences is TRUE?
Exam C2090-424 - admin post to:2017-07-20 read more

Which of the following environment variables can help in verifying whether data is evenly partitioned across all nodes?
Exam C2090-424 - admin post to:2017-07-20 read more

Which of the following is TRUE about Transformer Stage when $APT_TRANSFORM_COMPILE_OLD_NULL_HANDLING is set?
Exam C2090-424 - admin post to:2017-07-20 read more

Which of the following is the default data type for the Aggregator stage during calculation?
Exam C2090-424 - admin post to:2017-07-20 read more

Which of the following is TRUE about working with assets and artifacts?
Exam C2090-424 - admin post to:2017-07-20 read more

Which is NOT a valid native operator for OSH?
Exam C2090-424 - admin post to:2017-07-20 read more

A job consist of Sequential File Stage -> Copy Stage using auto partitioning -> Sequential File stage. We need the target Sequential File stage rows to be in the same order as the source file. Which collection algorithm should be chosen in the target Sequential File stage?
Exam C2090-424 - admin post to:2017-07-20 read more

Which restructure stage has a single reject link?
Exam C2090-424 - admin post to:2017-07-20 read more

Which of the following will run the DataStage job in the Unix environment for the domain is1:9445, server is1 for the user srv_etl?
Exam C2090-424 - admin post to:2017-07-20 read more

How do you create a shared table definition from the DataStage client?
Exam C2090-424 - admin post to:2017-07-20 read more

When building an UPDATE statement in SQL Query builder, which of the following is TRUE?
Exam C2090-424 - admin post to:2017-07-20 read more

You are experiencing performance issues for a given job. You are assigned the task of understanding what is happening at run time for that job. What steps should you take to understand the job performance issues? (Choose two.)
Exam C2090-424 - admin post to:2017-07-20 read more

Your job consists of a DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another DB2 Connector stage. The following two Balanced Optimizer options have been selected:
- Push processing to data sources
- Push processing to data targets The following two Balanced Optimizer options have NOT been selected:
- Push data reduction processing to data targets
- Push all processing into the(target)data server Assuming the job design allows for maximum optimization, what does the optimized job design look like?
Exam C2090-424 - admin post to:2017-07-20 read more

Which of the following is an FTP Collection method?
Exam C2090-424 - admin post to:2017-07-20 read more

Which of the following will determine the running row number within a group?
Exam C2090-424 - admin post to:2017-07-20 read more

Which of the following statements about checkpoint/restart is TRUE?
Exam C2090-424 - admin post to:2017-07-20 read more

When you read or write to a sequential file, and wish to have a value be identified with DataStage as NULL, which of the following is the correct option?
Exam C2090-424 - admin post to:2017-07-20 read more

Which partitioning method requires a key?
Exam C2090-424 - admin post to:2017-07-20 read more

Record Count property is set to zero in Connector stage. How many rows are written out?
Exam C2090-424 - admin post to:2017-07-20 read more

Which statement is TRUE?
Exam C2090-424 - admin post to:2017-07-20 read more

Which of the following is the correct schema format for a Time column?
Exam C2090-424 - admin post to:2017-07-20 read more

Which statement about shared containers is TRUE?
Exam C2090-424 - admin post to:2017-07-20 read more

A job is designed with 3 Join stages in sequence. Join_1 keys are "Account", "Customer" and "PO_Date" Join_2 keys are "Account", "Customer" and "Txn" Join_3 keys are "Account", "Product_CD" and "Txn" Which of the following will lead to the best run time performance?
Exam C2090-424 - admin post to:2017-07-20 read more

You want to retain the record with the largest value in the TotalAmount column for each CustID and ProductType using a Remove Duplicates stage. How can this be accomplished?
Exam C2090-424 - admin post to:2017-07-20 read more

Which client Tool is used to export environment variables from a Project?
Exam C2090-424 - admin post to:2017-07-20 read more

What COBOL data type is defined by Decimal data within the Complex Flat File stage?
Exam C2090-424 - admin post to:2017-07-20 read more

Which of the following locations will allow you to obtain a job's runtime logs? (Choose two.)
Exam C2090-424 - admin post to:2017-07-20 read more

In order to use Cognos TM1 Connector, which statement is TRUE?
Exam C2090-424 - admin post to:2017-07-20 read more

Your job aggregates data before writing the results out to a DB2 table. You have since learned that this job will be required to aggregate very large amounts of data. To ensure high performance you create a new, non-default configuration file for the job that defines a node pool named "highperfnodes" that includes only nodes with very high processing power. What additional design changes do you need to make to the job to ensure that it aggregates the data using the "highperfnodes" pool? (Choose two.)
Exam C2090-424 - admin post to:2017-07-20 read more

Parallel job column definitions have an SQL type associated with them. Which of the following is TRUE?
Exam C2090-424 - admin post to:2017-07-20 read more

A Parameter Set is a named object that can contain which of the following?
Exam C2090-424 - admin post to:2017-07-20 read more

Which Slowly Changing Dimension (SCD) stage statement is TRUE?
Exam C2090-424 - admin post to:2017-07-20 read more

Which of the following is NOT a valid use of stage variables?
Exam C2090-424 - admin post to:2017-07-20 read more

By default, how much internal memory does the Sort use per partition?
Exam C2090-424 - admin post to:2017-07-20 read more

The encrypt.sh or the encrypt.bat script can be used to do which of the following?
Exam C2090-424 - admin post to:2017-07-20 read more

The APT_SubProcessOperator is used for what purpose?
Exam C2090-424 - admin post to:2017-07-20 read more

Which one of the following stages requires a schema file when using Runtime Column Propagation?
Exam C2090-424 - admin post to:2017-07-20 read more

Which one of the following is NOT an XML Pack stage?
Exam C2090-424 - admin post to:2017-07-20 read more

Archive files can contain assets from multiple exports of multiple tools. When importing into a project from an archive file with the istool command, which order of asset types below would yield the best performance?
Exam C2090-424 - admin post to:2017-07-20 read more

In your project there is a top level Sequencer job which has multiple sub sequencers and jobs. You have to move this Sequencer job to a new project. How do you determine which objects have to be exported?
Exam C2090-424 - admin post to:2017-07-20 read more

For very large records, you may need to set the following environment variable with an appropriate value in order to allow the job to run successfully:
Exam C2090-424 - admin post to:2017-07-20 read more

Which of the following is TRUE?
Exam C2090-424 - admin post to:2017-07-20 read more

Which Connector Stage doesn't support reject Link
Exam C2090-424 - admin post to:2017-07-20 read more

Select the correct command to reset a password to Info1234 for user srv_etl in the Information Server internal registry, in the Unix environment.
Exam C2090-424 - admin post to:2017-07-20 read more