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

Data Stage Interview Questions

Questions Answers Views Company eMail

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 5839

data stores in which location while using data set stage as the target?

IBM, TCS,

1 7397

what is snow flack schema?

2 6397

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2046

Why we use parameters instead of hard code in datastage.

IBM,

2 7659

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

Infosys, TCS,

1 5692

How can we do null handling in sequential files?

Reliance,

3 17857

can we half project in parallel jobs and half project in server jobs?

Infosys, L&T,

4 10807

what are the different type of errors in datastage?

Wipro,

2 9065

30 jobs are running in unix.i want to find out my job.how to do this?Give me command?

3 9903

how to abort the job its matain duplicates?

TCS,

2574

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 6493

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 7870

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

Polaris,

2359

I have a few records all are same structures data, I want to store data in multiple targets how?

Polaris,

4 8880

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is a folder? Difference types of stages?

1174

What is ds designer?

1103

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2212

What is quality stage?

987

Where the datastage stored his repository?

1089

AGGREGATOR default datatype

1460

Can you explain tagbatch restructure operator?

1177

Define oconv () and iconv () functions in datastage?

1416

what is the use of surogate key in datastage

2309

How many Key we can define in remove duplicate stage?

1383

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3124

how do u catch bad rows from OCI stage? And what CLI stands for?

2800

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3345

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

2162

What are the different common services in datastage?

1284

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