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 13622

When we will go for Data elements?

TCS,

3 10333

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

TCS,

3 20649

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

TCS,

7 16344

How to create user defined environment varibale(parameter)?

TCS,

1 8002

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

Wipro,

12 30120

In merge stage can we update the values?

TCS,

3 12788

why do u need the IOS upgradation in a FC switch

IBM,

2224

describe the Steps to confiure a Qlogic switch

IBM,

2328

which r the connectors used in san?

2142

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 9101

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 5135

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

Wipro,

12 25551

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

IBM,

3 12672

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

Semantic Space,

5 13706

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is aggtorec restructure operator?

1342

What are the steps required to kill the job in Datastage?

1149

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1833

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

2166

Lookup constraints

1200

What are datastage sequences?

1057

Explain usage analysis in datastage?

1095

What is meta stage?

1131

How to perform incremental load in datastage?

1126

Differentiate between datastage and informatica?

1140

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

2749

Give an idea of system variables.

962

What is staging variable?

1027

What are stage variables and constants?

1096

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2837

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