TOP DataStage Interview Questions and Answers

Read Latest DataStage Interview Questions and Answers for Freshers, 2+ Years Experienced Q and A with Explanation PDF.

What can we do with DataStage Director?

Validating, Scheduling, Executing and Monitoring Jobs (server Jobs).

What are stage variables?

Stage variables are declaratives in Transformer Stage used to store values. Stage variables are active at the run time. (Because memory is allocated at the run time).

How do you handle the version controls?

Ascential have a separate product called ( Version Control ),which is used to handle version control.

Did you use the conditional scheduling in your project?

Using Sequencer Job we can create the conditional scheduling.

What are the command line functions that import and export the DS jobs?

dsimport.exe : imports the DataStage components.
dsexport.exe : exports the DataStage components.

What is transformer stage?

Transformer stages do not extract data or write data to a target database. They are used to handle extracted data, perform any conversions required, and pass data to another Transformer stage or a stage that writes data to a target data table.

How we can reuse the components?

Using the Shared and Local Containers.

How do you eliminate duplicate rows?

Data Stage provides us with a stage Remove Duplicates in Enterprise edition. Using that stage we can eliminate the duplicates based on a key column.

What is the difference between primary key and partition key?

Primary Key is a combination of unique and not null. It can be a collection of key values called as composite primary key. Partition Key is a just a part of Primary Key. There are several methods of partition like Hash, DB2, and Random etc. While using Hash partition we specify the Partition Key.

How we can reuse the components?

Using the Shared and Local Containers.

How do you schedule or monitoring the job?

Using the DataStage Director we can schedule or monitor the job.

What is the default cache size?

Default cache size is 256 MB.

What is the difference between join stage and merge stage?

JOIN : Performs join operations on two or more data sets input to the stage and then outputs the resulting dataset.
MERGE : Combines a sorted master data set with one or more sorted updated data sets. The columns from the records in the master and update data set s arc merged so that the out put record contains all the columns from the master record plus any additional columns from each update record that required.

What is meta data repository?

Meta Data is a data about the data. It also contains
* Query statistics
* ETL statistics
* Business subject area
* Source Information
* Target Information
* Source to Target mapping Information

What is the difference between active and passive Stage?

Passive Stages are used for data extraction and loading.
Active Stage are used to implements and process the business rules


Popular posts from this blog

TOP Agile Testing Interview Questions and Answers

Latest Agile Testing Interview Questions and Answers

Most Asked ADO.NET Interview Questions and Answers