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?

2105

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 7227

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 8225

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

IBM,

1 4308

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 13131

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 5735

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

IBM,

2 8745

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 14347

How to generate surrogate key without using surrogate key stage?

IBM,

6 30793

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

IBM,

1 4289

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 5606

How many number of reject links merge stage can have?

TCS,

7 15215

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

TCS,

3 18722

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

TCS,

3 9987

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

4 27003

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2173

What are the differences between datastage and informatica?

1177

What are routines in datastage? Enlist various types of routines.

1101

Define repository tables in datastage?

1157

What are the different types of lookups in datastage?

1054

How a server job can be converted to a parallel job?

1094

What steps should be taken to improve Datastage jobs?

1073

what is the difference between == and eq in UNIX shell scripting?

1500

What is difference between join, merge and lookup stage?

1095

Define Routines and their types?

1185

why do u need the IOS upgradation in a FC switch

2281

options available in sequence job to run,validate?

1316

What are the main differences you have observed between 7.x and 8.x version of datastage?

1088

What is the difference between operational data stage (ods) and data warehouse?

1240

Can we use target hash file as a lookup ?

3326

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