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 is audit table?

1 6675

How to enter a log in auditing table whenever a job get finished?

L&T,

2 13065

1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?

Mind Tree,

2 5445

Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?

TCS,

1 4717

what is use of SDR function?

CGI,

5225

what is the use of DSattchJob?DetachJob? where can we find it?

IBM,

2330

root tree will find which is server job and which is parallel job?

IBM,

2039

how can we create rank using datastage?what is the meaning of rank?

IBM,

8856

how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel

Wipro,

3 9858

is it possible to access the same job by two users at a time in DataStage?

IBM,

2 6664

where the log files or tables can store in DS?

IBM,

2 6717

where we use config file as parameter ?

IBM,

1 6188

job locking methods? How can we unlock the job?

IBM,

3 9723

Is there any possibility to generate alphanumeric surrogate key?

ABC, IBM,

3 12027

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

IBM,

2872

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the flow of loading data into fact & dimensional tables?

1112

What is difference between symmetric multiprocessing and massive parallel processing?

1198

What are the various kinds of the hash file?

1195

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2225

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

2675

Why do we use exception activity in Datastage?

1370

What is the sortmerge collector?

1176

Describe the main features of datastage?

1125

What is difference between join, merge and lookup stage?

1149

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

822

What are datastage sequences?

1168

Difference between server jobs & parallel jobs?

1130

How to read multiple files using a single datastage job if files have the same metadata?

1299

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2547

What is the differentiate between data file and descriptor file?

1412

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