Data Stage Interview Questions
Questions Answers Views Company eMail

Define Data Stage?

647

Define APT_CONFIG in Datastage?

668

Differentiate between Join, Merge and Lookup stage?

650

What is the method of removing duplicates, without the remove duplicate stage?

592

Define Routines and their types?

627

Define Job control?

681

Why do we use exception activity in Datastage?

732

How one source columns or rows to be loaded in to two different tables?

668

What is a merge?

674

Why fact table is in normal form?

683

Whats difference betweeen operational data stage (ods) and data warehouse?

675

How the ipc stage work?

680

What is the difference between the local container and shared container?

654

What are the repository tables in datastage?

831

What are the job parameters?

712


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Describe stream connector?

834


how to sort two columns in single job in datastage.

2549


What is a folder? Difference types of stages?

636


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

960


what is the use of surogate key in datastage

1825






what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

668


Can you explain tagbatch restructure operator?

707


How many types of hash files are there?

616


What are the different common services in datastage?

708


how to delete one row in target dataset

2591


What are transforms and what is the differenece between routines and transforms?

619


What are data elements?

664


Terminate Activity

842


How do you start developing a datastage project?

663


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

369