Data Stage Interview Questions
Questions Answers Views Company eMail

What are the partitioning techniques available in link partitioner?

1744

What is the purpose of interprocessor stage in server jobs?

ASD Lab,

1718

Can you filter data in hashed file?

3334

How many Nodes configuration file you used in your last project?

1 3397

Tell me the syntax of Configuration file?

1 4170

Explain the situation where you have applied SCD in your project?

1550

What are the third party tools you used in your project?

IBM,

1 2471

How do you design PX Routines ?

1 2598

What is the use of Row generator stage?

2 11999

How you Implemented SCD Type 1 & Type 2 in your project?

3686

On which Dimension Table you implemented SCD Type in your Project

1564

How you Remove the Dataset in Unix?

5 19525

What is the difference b/w Hash file and Lookup Fileset stages?

1 9912

What is the default padding character?

IBM,

3 13950

What are the partition techniques available in your last project?

1 4571


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the types of containers?

667


what is the use of surogate key in datastage

1804


What are the different layers in the information server architecture?

634


Define project in datastage?

657


Differentiate between odbc and drs stage?

583






if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1753


Differentiate between data file and descriptor file?

610


What is the precedence of stage variables,derivations, and constraints?

584


How do you run datastage job from the command line?

587


What are the job parameters?

694


Name the different types of Lookups in Datastage?

718


Triggers,VIEW,Procedures

785


Can we use target hash file as a lookup ?

2806


Is possible to create skid in dim,fact tables?

2178


What are the enhancements made in datastage 7.5 compare with 7.0?

702