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 13924

When we will go for Data elements?

TCS,

3 10515

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

TCS,

3 20821

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

TCS,

7 16640

How to create user defined environment varibale(parameter)?

TCS,

1 8118

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

Wipro,

12 30573

In merge stage can we update the values?

TCS,

3 12959

why do u need the IOS upgradation in a FC switch

IBM,

2281

describe the Steps to confiure a Qlogic switch

IBM,

2383

which r the connectors used in san?

2188

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 9285

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 5215

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

Wipro,

12 26083

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

IBM,

3 12813

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

Semantic Space,

5 13923

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

On which Dimension Table you implemented SCD Type in your Project

2044

What is orabulk stage?

1047

Define repository tables in datastage?

1157

Where do the datastage jobs get stored?

1216

Define Data Stage?

1091

Which algorithm you used for your hashfile?

1182

How do you run datastage job from the command line?

1091

Difference between data warehousing and olap?

1089

how do u catch bad rows from OCI stage? And what CLI stands for?

2800

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1538

What is the different type of jobs in datastage?

974

How do you reject records in a transformer?

1124

Differentiate between datastage and informatica?

1181

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2968

Is the value of staging variable stored temporarily or permanently?

998

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