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,

3954

What is a range lookup?

IBM,

2 7232

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

Wipro,

2352

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 7680

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

IBM,

3 9396

how can find maximum salary by using Remove duplicate stage?

IBM,

5 13669

what are the types of nodes

HCL, TCS,

4 24678

how to unlock a locked job in datastage 8.0

HCL,

3 22669

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3437

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

Syntel, TCS,

6 32281

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

1 5127

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

1 6431

what is a force compile

Cap Gemini, IBM,

2 8578

what is a message handler

IBM,

3 10107

what is the use of invokation id

IBM,

2 10338


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

How many areas for files does datastage have?

866


What are the types of hashed files in data stage

866


Can you filter data in hashed file?

3562


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.

3760


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

1886


What is size of a transaction and an array means in a datastage?

1034


Can you define merge?

870


What is the difference between datastage and informatica?

852


How do you schedule or monitoring the job?

877


what is ds administrator used for?

922


Name the command line functions to import and export the DS jobs?

913


What is merge stage?

976


Define APT_CONFIG in Datastage?

855


How do you import and export data into datastage?

957


Different ways a project can be moved to production ?...example ….export-import and Version control.

2190