Data Stage Interview Questions
Questions Answers Views Company eMail

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...

UHG,

3941

What is a range lookup?

IBM,

2 7209

what is 'reconsideration error' and how can i respond to this error and how to debug this

Wipro,

2333

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

Wipro,

2 7653

How to display all the duplicate records from the oracle Table?

IBM,

3 9340

how can find maximum salary by using Remove duplicate stage?

IBM,

5 13612

what are the types of nodes

HCL, TCS,

4 24624

how to unlock a locked job in datastage 8.0

HCL,

3 22638

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3428

how to remove duplicates in transformer stage by using stage variables?one example?

Syntel, TCS,

6 32206

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 5105

how to find out number of records imported into source file?

1 6406

what is a force compile

Cap Gemini, IBM,

2 8534

what is a message handler

IBM,

3 10075

what is the use of invokation id

IBM,

2 10312


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2491


Why fact table is in normal form?

877


Where do you see different stages in the designer?

811


Have you used Unstructured data?

1025


What are the stages in datastage?

817


What is datastage?

836


What are iconv and oconv?

963


options available in sequence job to run,validate?

1053


What are the partitioning techniques available in link partitioner?

2011


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

577


What are the benefits of datastage?

925


What are orabulk and bcp stages?

851


Define orabulk and bcp stages?

886


What is meta stage?

905


how to delete one row in target dataset

2820