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

Data Stage Interview Questions

Questions Answers Views Company eMail

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2115

what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????

TCS,

1 7234

cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle

TCS,

3 8235

Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.

IBM,

1 4312

Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?

IBM,

7 13152

Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

CGI,

1 5746

How can u write exception handling in seq file????

IBM,

2 8755

i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance

IBM,

2 14355

How to generate surrogate key without using surrogate key stage?

IBM,

6 30813

How can we select pr retrieve the particular row in dataset by using orchadmin command?

IBM,

1 4297

I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

CGI,

1 5616

How many number of reject links merge stage can have?

TCS,

7 15235

Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

TCS,

3 18738

Can we use Round Robin for aggregator?is there any benefit underlying?

TCS,

3 9996

How to add zero "0" before record in a field?

4 27018

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the different common services in datastage?

1290

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.

3350

What is difference between symmetric multiprocessing and massive parallel processing?

1149

What are the functionalities of link partitioner and link collector?

1011

What are the different types of lookups in datastage?

1059

What are the repository tables in datastage?

1309

Difference between server jobs & parallel jobs?

1083

Explain connectivity between datastage with datasources?

985

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

932

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1748

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1419

What are transforms and what is the differenece between routines and transforms?

1066

How do you register plug-ins?

969

Highlight the main features of datastage?

1163

What is the difference between datastage and informatica?

1123

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