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

Data Stage Interview Questions

Questions Answers Views Company eMail

What is RCP

CGI, CTS,

5 21790

How can we achive parallelism

CTS,

1 7849

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

TCS,

4 10620

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

HCL,

2186

1)Source file contains one record, I want 100 records in target file.

3 9319

Two source files contains same meta data third file contains different data types can I funnel that file.

2 8155

3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 6103

I have 100 records how can I load at a time from the single time

1 5280

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 6736

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 8884

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4044

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

Cap Gemini,

11 21254

source file contains 100 records, i want 10 records in target file how it possible in datastage

IBM,

6 24454

one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?

IBM,

8 13275

diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

TCS,

1 4156

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the precedence of stage variables,derivations, and constraints?

1086

How to Remove Duplicate using SQL?

1370

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2063

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

3756

How to RD using transformer?

1424

Can you define merge?

1123

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3124

What can we do with datastage director?

1238

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

932

Can you explain link buffering?

1179

How to reverse the string using SQL?

1527

CHANGE CAPTURE

1300

Does datastage support slowly changing dimensions ?

1105

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1550

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2224

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