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 22367

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,

3403

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

JPMorgan Chase,

2 7501

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 13335

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 9866

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,

2292

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 11813

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

IBM,

1 6127

How to convert RGB Value to Hexadecimal values in datastage?

4057

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

1 5629

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

US Technology,

6 9844

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 14369

1)How to Duplicate Records Delete in Sequential file?

IBM, TCS,

4 15385

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 10796

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

3810

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

table actions available in oracle connector?

1655

What are iconv and oconv?

1298

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2247

What are the primary usages of datastage tool?

1128

EXPLAIN SCD

1450

What could be a data source system?

1098

What are routines in datastage? Enlist various types of routines.

1154

What are the components of ascential data stage?

1241

Nls stands for what in datastage?

1236

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2872

Describe the architecture of datastage?

1060

What are system variables and sequencers in datastage

1182

What is the difference between Datastage 7.5 and 7.0?

1150

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1561

what is the use of materialized view?

1638

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