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

Data Stage Interview Questions

Questions Answers Views Company eMail

Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.

IBM,

1 5870

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

IBM,

3 9097

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

Cap Gemini, IBM,

2 9621

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

CGI,

2493

how do you pass parameters in a script?

L&T,

1 7289

whats difference between ls -ltr and ls -lrt?

L&T,

5 40681

why do we need a datawarehouse when we have databases to store data?

L&T,

1 5533

i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

L&T,

4 10151

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

L&T,

2 9157

whats relation between configuration file and datasets?

L&T, Wipro,

2 11317

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

ABC, TCS,

3794

what is diff b/w datastage 8.1,8.5,8.7?

IBM,

1 9646

how does work server jobs?

1 4453

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2901

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

UHG,

4 10760

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the repository tables in datastage?

1306

How do you start developing a datastage project?

1103

Why do we use exception activity in Datastage?

1314

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

1065

how do u catch bad rows from OCI stage? And what CLI stands for?

2800

What is process model?

1975

What can we do with datastage director?

1237

What is meta stage?

1180

1087

Does datastage support slowly changing dimensions ?

1104

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

4129

How will you move hashed file from one location to another location?

2151

Describe stream connector?

1305

If you want to use the same piece of code in different jobs, how will you achieve it?

1153

What are orabulk and bcp stages?

1124

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