Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 11063

how to delete one row in target dataset

Satyam,

3122

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

HCL,

9 28649

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 31049

what is data mapping

2 7816

Which type of joins Merge stage can support?

IBM,

7 17009

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

EDS,

2514

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

EDS,

2541

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

EDS,

2741

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

2415

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 7917

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

IBM,

10 69060

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

Tech Mahindra,

2 10505

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 13739

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

2 19703

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Name the command line functions to import and export the DS jobs?

1155

What are system variables and sequencers in datastage

1115

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

2285

How a routine is called in datastage job?

1108

What is the difference between datastage and informatica?

1118

What are the enhancements made in datastage 7.5 compare with 7.0?

1148

Is possible to create skid in dim,fact tables?

2636

How can you write parallel routines in datastage PX?

1015

Where the datastage stored his repository?

1089

What are the partitioning techniques available in link partitioner?

2279

Explain ibm infosphere information server and highlight its main features?

1091

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1416

How do y read Sequential file from job control?

15960

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1039

What all are the different way to run a job?

1094

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