Data Stage Interview Questions
Questions Answers Views Company eMail

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

1626

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 6431

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 6804

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

IBM,

1 3602

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 10889

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 5012

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

IBM,

2 7577

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 13330

How to generate surrogate key without using surrogate key stage?

IBM,

6 28734

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

IBM,

1 3557

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 4794

How many number of reject links merge stage can have?

TCS,

7 12421

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

TCS,

3 17129

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

TCS,

3 8649

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

4 24952


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the difference between informatica and datastage?

642


Which warehouse using in your datawarehouse

1670


What is ibm datastage flow designer?

673


How and where you used hash file?

645


DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1024






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

697


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

608


How a source file is populated?

600


How many types of sorting methods are available in datastage?

616


What are the types of containers?

667


What are the different plug-ins stages used in your projects?

610


How do you remove duplicate values in datastage?

612


What are the stages in datastage?

626


What are stage variables?

628


Differentiate between data file and descriptor file?

608