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 5959

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 9244

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 9753

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

CGI,

2561

how do you pass parameters in a script?

L&T,

1 7378

whats difference between ls -ltr and ls -lrt?

L&T,

5 40909

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

L&T,

1 5603

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 10326

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 9267

whats relation between configuration file and datasets?

L&T, Wipro,

2 11427

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

ABC, TCS,

3853

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

IBM,

1 9729

how does work server jobs?

1 4548

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.

2957

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 10929

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Explain Quality stage?

1211

What are the steps needed to create a simple basic datastage job?

1308

How we can covert server job to a parallel job?

1260

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1922

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2776

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

1210

How to reverse the string using SQL?

1596

Why do we use exception activity in Datastage?

1373

What is the difference between passive stage and active stage?

1648

Difference between server jobs & parallel jobs?

1133

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

1113

What steps should be taken to improve Datastage jobs?

1120

describe the Steps to confiure a Qlogic switch

2438

What is job control?

1200

What are the features of datastage flow designer?

1099

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