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 5954

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 9242

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 7375

whats difference between ls -ltr and ls -lrt?

L&T,

5 40897

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

L&T,

1 5602

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 9260

whats relation between configuration file and datasets?

L&T, Wipro,

2 11422

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

ABC, TCS,

3852

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

IBM,

1 9726

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 10918

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

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

1278

What are the partitioning techniques available in link partitioner?

2328

What is the precedence of stage variables,derivations, and constraints?

1126

What all the types of jobs you developed?

1248

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2535

What is the difference between hashfile and sequential file?

1318

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3522

How can you write parallel routines in datastage PX?

1065

what is repositery?

1928

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

2213

What is meta stage?

1240

Explain connectivity between datastage with datasources?

1041

Give an idea of system variables.

1090

Can you highlight the main features of ibm infosphere information server?

1125

What are the types of jobs we have in datastage?

1122

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