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,

4147

What is a range lookup?

IBM,

2 7632

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

Wipro,

2560

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 8104

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

IBM,

3 9960

how can find maximum salary by using Remove duplicate stage?

IBM,

5 14498

what are the types of nodes

HCL, TCS,

4 25402

how to unlock a locked job in datastage 8.0

HCL,

3 23196

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3615

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

Syntel, TCS,

6 33386

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

1 5413

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

1 6732

what is a force compile

Cap Gemini, IBM,

2 9030

what is a message handler

IBM,

3 10685

what is the use of invokation id

IBM,

2 10831

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Nls stands for what in datastage?

1151

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2221

What is usage analysis in datastage?

1267

Differentiate between validated and Compiled in the Datastage?

1203

How to find value from a column in a dataset?

2154

What is the difference between in process and inter process?

1098

What is the flow of loading data into fact & dimensional tables?

1024

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2114

sed,awk,head

1417

On which Dimension Table you implemented SCD Type in your Project

1976

What is a merge in datastage?

1210

Can you explain repository tables in datastage?

1346

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

3135

how to sort two columns in single job in datastage.

2851

I have a few records just I want to store data in to targets cycling way how?

2307

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