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,

3997

What is a range lookup?

IBM,

2 7319

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

Wipro,

2402

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 7757

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

IBM,

3 9511

how can find maximum salary by using Remove duplicate stage?

IBM,

5 13790

what are the types of nodes

HCL, TCS,

4 24826

how to unlock a locked job in datastage 8.0

HCL,

3 22768

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3483

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

Syntel, TCS,

6 32458

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

1 5178

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

1 6482

what is a force compile

Cap Gemini, IBM,

2 8680

what is a message handler

IBM,

3 10204

what is the use of invokation id

IBM,

2 10424


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Difference between sequential file and data set?

928


Differentiate between Join, Merge and Lookup stage?

892


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

901


What are the different options associated with dsjob command?

1237


What is the precedence of stage variables,derivations, and constraints?

849


Can you explain kafka connector?

1082


What are data elements?

895


Could anyone give brief explanation bout datastage admin

2198


what are the devoleper roles in real time? plz tell i am new to datastage....

1919


if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

1988


What is a merge?

899


Is the value of staging variable stored temporarily or permanently?

810


What is job control?

839


Which warehouse using in your datawarehouse

1929


Define ds designer?

1045