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

Data Stage Interview Questions

Questions Answers Views Company eMail

I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.

8 22105

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

JPMorgan Chase,

3343

how can or from where we can get reference data in scd type2 implementation?

JPMorgan Chase,

2 7381

hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

IBM,

4 13171

I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know

6 9671

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

IBM,

2240

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

IBM,

5 11654

Explain briefly scd type2 in datastage7.5x2(parallel)

IBM,

1 6023

How to convert RGB Value to Hexadecimal values in datastage?

3994

SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS

1 5547

source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

US Technology,

6 9664

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

Cap Gemini,

6 14164

1)How to Duplicate Records Delete in Sequential file?

IBM, TCS,

4 15174

Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.

7 10578

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3746

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is merge stage?

1301

What are routines in datastage?

1325

What are iconv and oconv?

1240

What are the various kinds of the hash file?

1145

what is the use of skid in reporting?

2379

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

3460

What is difference between join, merge and lookup stage?

1092

Define data aggregation?

1093

Describe stream connector?

1305

Can we use target hash file as a lookup ?

3323

What is job control?

1107

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

1004

What is a merge?

1159

What are the different kinds of views available in a datastage director?

1026

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

1146

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