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,

3772

What is a range lookup?

IBM,

2 6757

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

Wipro,

2127

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 7291

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

IBM,

3 8761

how can find maximum salary by using Remove duplicate stage?

IBM,

5 12911

what are the types of nodes

HCL, TCS,

4 23730

how to unlock a locked job in datastage 8.0

HCL,

3 21988

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3280

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

Syntel, TCS,

6 31124

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

1 4798

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

1 6149

what is a force compile

Cap Gemini, IBM,

2 8128

what is a message handler

IBM,

3 9545

what is the use of invokation id

IBM,

2 9831


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Nls stands for what in datastage?

738


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

968


what is ds administrator used for?

734


Lookup constraints

855


What are the some differences between 7.x and 8.x version of datastage?

753






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

2755


How many types of views are there in a datastage director?

845


What are the areas of application?

677


Define Merge?

889


Notification Activity

907


How to convert RGB Value to Hexadecimal values in datastage?

3468


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.

3513


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

789


How and where you used hash file?

673


Explain Quality stage?

678