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,

3879

What is a range lookup?

IBM,

2 7061

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

Wipro,

2241

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 7515

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

IBM,

3 9157

how can find maximum salary by using Remove duplicate stage?

IBM,

5 13386

what are the types of nodes

HCL, TCS,

4 24294

how to unlock a locked job in datastage 8.0

HCL,

3 22483

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3372

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

Syntel, TCS,

6 31873

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

1 4983

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

1 6306

what is a force compile

Cap Gemini, IBM,

2 8396

what is a message handler

IBM,

3 9904

what is the use of invokation id

IBM,

2 10126


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

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

1883


How to convert RGB Value to Hexadecimal values in datastage?

3591


What is the use of datastage designer?

747


What is a datastage job?

732


How to reverse the string using unix?

2991






whom do you report?

1628


Where do the datastage jobs get stored?

848


What is the difference between the local container and shared container?

765


State the difference between an operational datastage and a data warehouse?

720


What is the process of killing a job in datastage?

688


To see hidden files in LINIX?

1058


how to delete one row in target dataset

2735


how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

646


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

1897


Name the different sorting methods in datastage.

731