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 5778

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 8958

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 9456

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

CGI,

2407

how do you pass parameters in a script?

L&T,

1 7181

whats difference between ls -ltr and ls -lrt?

L&T,

5 40416

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

L&T,

1 5435

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 9964

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 9054

whats relation between configuration file and datasets?

L&T, Wipro,

2 11187

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

ABC, TCS,

3738

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

IBM,

1 9575

how does work server jobs?

1 4374

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.

2839

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 10578

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2169

What are routines in datastage? Enlist various types of routines.

1047

How can we improve the performance in datastage?

1061

What are the different layers in the information server architecture?

1080

Differentiate between datastage and datastage tx?

1008

What is job control?

1044

Can you explain tagbatch restructure operator?

1118

How can you write parallel routines in datastage PX?

976

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3079

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1336

what is repositery?

1774

Why do you need stage variables?

1136

Why do we use exception activity in Datastage?

1231

Could anyone give brief explanation bout datastage admin

2316

What is the difference between informatica and datastage?

1151

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