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,

3417

What is difference between 8.1 , 8.5 and 9.1 ?

IBM,

1 16070

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 11544

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

1 21432

what is set mapping in datastage??

ADP,

2 11086

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 11098

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

2825

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 13543

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 28316

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 8497

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 12491

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

2 8527

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 11104

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 12991

how to call sequential generator in datastage?

IBM,

1 4799

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the processing stages?

1041

how to delete one row in target dataset

3065

in oracle target stage when we use load option and when we use upsert option?

2208

Differentiate between operational datastage (ods) and data warehouse?

1122

State the difference between an operational datastage and a data warehouse?

1063

What all the types of jobs you developed?

1116

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?

2172

What are data elements?

1109

How to reverse the string using SQL?

1430

What are the different plug-ins stages used in your projects?

1032

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2171

Define Data Stage?

1044

Could anyone give brief explanation bout datastage admin

2316

Why we use surrogate key?

1160

What is the purpose of pivot stage and types of containers in datastage

997

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