Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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,

4188

What is a range lookup?

IBM,

2 7771

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

Wipro,

2631

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 8199

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

IBM,

3 10132

how can find maximum salary by using Remove duplicate stage?

IBM,

5 14711

what are the types of nodes

HCL, TCS,

4 25564

how to unlock a locked job in datastage 8.0

HCL,

3 23328

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3650

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

Syntel, TCS,

6 33655

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

1 5500

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

1 6809

what is a force compile

Cap Gemini, IBM,

2 9144

what is a message handler

IBM,

3 10840

what is the use of invokation id

IBM,

2 10964

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

How the ipc stage work?

1127

What is the difference between in process and inter process?

1146

what is the custome stage in datastage? how can we impliment that one? plz tell me

2367

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2212

What is the process of killing a job in datastage?

1018

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1415

What is the difference between orabulk and bcp stages?

1025

What are the different kinds of views available in a datastage director?

1030

in oracle target stage when we use load option and when we use upsert option?

2285

what is the difference between == and eq in UNIX shell scripting?

1500

what is repositery?

1843

how to delete one row in target dataset

3122

What are the difference types of stages?

1214

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

3166

how to add a new records into source?

2000

For More Un-Answered { Data Stage } Questions Click Here