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

Data Stage Interview Questions

Questions Answers Views Company eMail

If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically

TCS,

6 13638

When we will go for Data elements?

TCS,

3 10341

what is the unix script to run the job? Please mention commands which we use often?

TCS,

3 20659

Difference in the implementation of lookup and join stages,in joining two tables?

TCS,

7 16367

How to create user defined environment varibale(parameter)?

TCS,

1 8006

what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?

Wipro,

12 30150

In merge stage can we update the values?

TCS,

3 12798

why do u need the IOS upgradation in a FC switch

IBM,

2227

describe the Steps to confiure a Qlogic switch

IBM,

2332

which r the connectors used in san?

2147

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 9115

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..

1 5142

With out using Funnel Stage, how to populate the data from different sources to single target

Wipro,

12 25580

Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?

IBM,

3 12684

Hi This is Vijay How Can u Read the data from sequential file Parall'y?

Semantic Space,

5 13720

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the difference between odbc and drs stage?

1047

What is meta stage?

1135

What are the main differences you have observed between 7.x and 8.x version of datastage?

1025

What is quality stage?

942

What is the importance of the exception activity in datastage?

1018

how to add a new records into source?

1937

what is use of SDR function?

5129

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5047

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

1033

Can you explain kafka connector?

1247

Name the third party tools that can be used in datastage?

1024

What is the difference between datastage and datastage tx?

1010

what is repositery?

1772

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.

3973

How to RD using transformer?

1367

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