Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Stage Interview Questions

Questions Answers Views Company eMail

What are the partitioning techniques available in link partitioner?

2272

What is the purpose of interprocessor stage in server jobs?

ASD Lab,

2230

Can you filter data in hashed file?

3772

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

1 4250

Tell me the syntax of Configuration file?

1 4993

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

2034

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

IBM,

1 3275

How do you design PX Routines ?

1 3394

What is the use of Row generator stage?

2 13274

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

4126

On which Dimension Table you implemented SCD Type in your Project

2024

How you Remove the Dataset in Unix?

5 21619

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

1 10901

What is the default padding character?

IBM,

3 15621

What are the partition techniques available in your last project?

1 5310

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the different options associated with dsjob command?

1427

What is staging variable?

1084

What is usage analysis in datastage?

1300

What are some prerequisites for datastage?

1094

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1408

What are the functionalities of link partitioner and link collector?

1007

Differentiate between hash file and sequential file?

1067

What are iconv and oconv?

1240

what is 'reconsideration error' and how can i respond to this error and how to debug this

2625

project Steps,hits, Project level HArd things,Solved methods?

2124

What is the difference between validated and compiled in the datastage?

1282

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4036

Notification Activity

1398

Describe link sort?

1011

Explain usage analysis in datastage?

1158

For More Un-Answered { Data Stage } Questions Click Here