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,

3752

What is a range lookup?

IBM,

2 6695

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

Wipro,

2109

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 7250

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

IBM,

3 8709

how can find maximum salary by using Remove duplicate stage?

IBM,

5 12821

what are the types of nodes

HCL, TCS,

4 23606

how to unlock a locked job in datastage 8.0

HCL,

3 21900

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3252

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

Syntel, TCS,

6 30943

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

1 4750

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

1 6106

what is a force compile

Cap Gemini, IBM,

2 8086

what is a message handler

IBM,

3 9487

what is the use of invokation id

IBM,

2 9779


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Explain the datastage parallel extender (px) or enterprise edition (ee)?

718


What are the partitioning techniques available in link partitioner?

1745


Why do we use link partitioner and link collector in datastage?

675


What is datastage engine?

721


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2016






What is a merge in datastage?

758


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1917


How do you run datastage job from the command line?

587


What is ibm datastage?

595


How to read multiple files using a single datastage job if files have the same metadata?

727


1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3493


What is the purpose of pivot stage and types of containers in datastage

603


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2738


How many areas for files does datastage have?

631


Why fact table is in normal form?

664