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,

3823

What is a range lookup?

IBM,

2 6909

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

Wipro,

2189

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 7408

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

IBM,

3 8947

how can find maximum salary by using Remove duplicate stage?

IBM,

5 13171

what are the types of nodes

HCL, TCS,

4 24046

how to unlock a locked job in datastage 8.0

HCL,

3 22228

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3334

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

Syntel, TCS,

6 31583

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

1 4879

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

1 6227

what is a force compile

Cap Gemini, IBM,

2 8276

what is a message handler

IBM,

3 9740

what is the use of invokation id

IBM,

2 9985


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Can you filter data in hashed file?

3426


What is oci?

923


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

686


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1791


How do you remove duplicate values in datastage?

701






What are the different types of lookups in datastage?

688


Can you explain tagbatch restructure operator?

782


Describe link sort?

718


Explain ibm infosphere information server and highlight its main features?

685


What is orabulk stage?

711


What is job control?

692


How do you import and export the datastage jobs?

802


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

775


what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

731


What is ibm datastage?

653