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 5875

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 9105

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 9631

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

CGI,

2498

how do you pass parameters in a script?

L&T,

1 7300

whats difference between ls -ltr and ls -lrt?

L&T,

5 40702

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

L&T,

1 5542

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 10164

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 9166

whats relation between configuration file and datasets?

L&T, Wipro,

2 11328

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

ABC, TCS,

3800

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

IBM,

1 9650

how does work server jobs?

1 4464

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.

2908

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 10766

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Name the third party tools that can be used in datastage?

1079

What is the difference between Datastage 7.5 and 7.0?

1098

what is 'reconsideration error' and how can i respond to this error and how to debug this

2634

why do u need the IOS upgradation in a FC switch

2283

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2238

Explain datastage architecture?

1405

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

1150

how to delete one row in target dataset

3125

Describe link sort?

1018

How can we improve the performance in datastage?

1107

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2213

What is job control?

1120

What are the areas of application?

1152

Enlist various types of routines in datastage.

1259

What is the differentiate between data file and descriptor file?

1366

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