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 11433

When we will go for Data elements?

TCS,

3 8862

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

TCS,

3 19089

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

TCS,

7 14232

How to create user defined environment varibale(parameter)?

TCS,

1 7130

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

Wipro,

12 27008

In merge stage can we update the values?

TCS,

3 11347

why do u need the IOS upgradation in a FC switch

IBM,

1857

describe the Steps to confiure a Qlogic switch

IBM,

1923

which r the connectors used in san?

1778

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 7571

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 4563

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

Wipro,

12 22178

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

IBM,

3 11518

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

Semantic Space,

5 12107


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

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.

2420


What are the different kinds of views available in a datastage director?

589


What are some prerequisites for datastage?

605


What a datastage macro?

622


What is oci?

839






Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

3749


Enlist various types of routines in datastage.

633


Why do we use exception activity in Datastage?

700


what is repositery?

1280


What are the functionalities of link collector?

617


How do you run datastage job from the command line?

584


How to read the length of word in unix?

869


what is flow of project?

1546


What is the difference between validated and compiled in the datastage?

690


How do you generate sequence number in datastage?

614