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?

2102

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 7221

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 8222

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

IBM,

1 4297

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 13109

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 5726

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

IBM,

2 8741

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 14336

How to generate surrogate key without using surrogate key stage?

IBM,

6 30776

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

IBM,

1 4282

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 5596

How many number of reject links merge stage can have?

TCS,

7 15201

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

TCS,

3 18718

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

TCS,

3 9977

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

4 26991

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

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

2441

how many rows sorted in sort stage by default in server jobs

3997

Distinguish between informatica & datastage. Which one would you choose and why?

1004

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

2352

How do you run datastage job from the command line?

1081

How to manage date conversion in Datastage?

1134

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2275

explain about citrix scheduling tool in datastage

2448

How do you import and export data into datastage?

1228

What is ds designer?

1096

What is a ds designer?

1068

What is the use of datastage designer?

1151

How can we improve performance of data stage jobs?

1012

Why do we use link partitioner and link collector in datastage?

1133

How can you write parallel routines in datastage PX?

1011

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