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 13891

When we will go for Data elements?

TCS,

3 10496

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

TCS,

3 20805

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

TCS,

7 16604

How to create user defined environment varibale(parameter)?

TCS,

1 8110

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

Wipro,

12 30549

In merge stage can we update the values?

TCS,

3 12922

why do u need the IOS upgradation in a FC switch

IBM,

2279

describe the Steps to confiure a Qlogic switch

IBM,

2382

which r the connectors used in san?

2181

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 9259

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 5204

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

Wipro,

12 26039

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

IBM,

3 12798

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

Semantic Space,

5 13891

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Differentiate between Join, Merge and Lookup stage?

1090

How a routine is called in datastage job?

1095

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2079

project Steps,hits, Project level HArd things,Solved methods?

2123

Define orabulk and bcp stages?

1119

What are system variables and sequencers in datastage

1115

To see hidden files in LINIX?

1520

How to Remove Duplicate using SQL?

1360

Define APT_CONFIG in Datastage?

1068

how to delete one row in target dataset

3113

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2290

what is the difference between == and eq in UNIX shell scripting?

1498

what is the use of materialized view?

1561

What is the difference between the local container and shared container?

1096

If you want to use the same piece of code in different jobs, how will you achieve it?

1150

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