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 5775

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 8948

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 9446

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 7177

whats difference between ls -ltr and ls -lrt?

L&T,

5 40400

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 9951

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 9049

whats relation between configuration file and datasets?

L&T, Wipro,

2 11186

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

ABC, TCS,

3736

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

IBM,

1 9570

how does work server jobs?

1 4370

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 10570

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the features of datastage flow designer?

993

Define Routines and their types?

1098

Triggers,VIEW,Procedures

1178

How to implement complex jobs in data stage?

1054

Does datastage support slowly changing dimensions ?

1054

how to add a new records into source?

1937

What is the project in datastage?

1051

Describe the architecture of datastage?

953

How to RD using transformer?

1367

Is it possible to query a hash file?

1953

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

2677

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

2760

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

954

Define ds designer?

1221

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1173

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