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,

3980

What is a range lookup?

IBM,

2 7269

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

Wipro,

2374

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 7706

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

IBM,

3 9448

how can find maximum salary by using Remove duplicate stage?

IBM,

5 13722

what are the types of nodes

HCL, TCS,

4 24751

how to unlock a locked job in datastage 8.0

HCL,

3 22707

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3457

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

Syntel, TCS,

6 32361

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

1 5154

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

1 6460

what is a force compile

Cap Gemini, IBM,

2 8619

what is a message handler

IBM,

3 10156

what is the use of invokation id

IBM,

2 10384

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the main features of datastage?

931

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2161

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

820

What are the types of jobs we have in datastage?

887

What are the primary usages of datastage tool?

869

What are the functionalities of link partitioner?

826

To see hidden files in LINIX?

1200

Which warehouse using in your datawarehouse

1907

Define ds designer?

1016

What are orabulk and bcp stages?

892

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

1011

How do you run datastage job from the command line?

847

What is meta stage?

945

What is the process of killing a job in datastage?

778

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

2148

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