Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Stage Interview Questions

Questions Answers Views Company eMail

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

CTS,

3460

What is difference between 8.1 , 8.5 and 9.1 ?

IBM,

1 16157

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

Caterpillar,

3 11731

What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 21530

what is set mapping in datastage??

ADP,

2 11177

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

Wipro,

2 11209

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2857

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

Cap Gemini,

5 13689

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

Cognizant, HCL, TIAA CREF,

8 28648

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

IBM,

1 8558

I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 12676

how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know

2 8623

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

HCL,

3 11234

My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.

Wipro,

6 13197

how to call sequential generator in datastage?

IBM,

1 4897

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

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.

2892

What are the various kinds of the hash file?

1145

What are sequencers?

1106

Name the command line functions to import and export the DS jobs?

1146

Distinguish between informatica & datastage. Which one would you choose and why?

1004

What is the difference between account and directory options ?

1177

What are the job parameters?

1219

what is the difference between == and eq in UNIX shell scripting?

1498

Can you filter data in hashed file?

3772

what is the custome stage in datastage? how can we impliment that one? plz tell me

2364

Name the different sorting methods in datastage.

1045

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

1228

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3644

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2275

What are the processing stages?

1095

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