Data Stage Interview Questions
Questions Answers Views Company eMail

1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.

4 10321

how to delete one row in target dataset

Satyam,

2845

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

HCL,

9 27140

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..

Cognizant, IBM, TCS, Virtusa,

9 29552

what is data mapping

2 7274

Which type of joins Merge stage can support?

IBM,

7 15747

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

EDS,

2300

1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?

EDS,

2305

What is a delta record? How you will read it?

EDS,

2382

i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me

2106

i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want

3 7176

What is the Difference Between DataStage 7.5 version and 8.1 Version?

IBM,

10 67601

what is the Difference Between Datastage Server Edition and Parallel Edition?

Tech Mahindra,

2 9864

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?

HCL,

4 12882

what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?

2 19167


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the difference between passive stage and active stage?

1083


How can we improve the performance in datastage?

859


How can one find bugs in job sequence?

1034


Difference between ‘validated ok’ and ‘compiled’ in data stage?

913


How to Remove Duplicate using SQL?

1065


What is oci?

1082


How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2307


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2088


what is flow of project?

1747


whom do you report?

1721


What are stage variables and constants?

912


What are the types of views in datastage director?

1532


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

808


What is meta stage?

933


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

720