Data Stage Interview Questions
Questions Answers Views Company eMail

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

1633

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 6455

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 6846

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

IBM,

1 3617

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 10942

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 5029

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

IBM,

2 7589

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 13348

How to generate surrogate key without using surrogate key stage?

IBM,

6 28775

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

IBM,

1 3575

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 4814

How many number of reject links merge stage can have?

TCS,

7 12475

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

TCS,

3 17170

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

TCS,

3 8684

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

4 24987


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is datastage?

647


What is size of a transaction and an array means in a datastage?

737


how to delete one row in target dataset

2584


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

1801


What are the types of containers in datastage?

703






What is the differentiate between data file and descriptor file?

861


To see hidden files in LINIX?

941


What are the benefits of datastage?

721


What is the method of removing duplicates, without the remove duplicate stage?

580


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

1916


How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2052


What are system variables and sequencers in datastage

604


How and where you used hash file?

655


What is the use of hoursfromtime() function in transformer stage in datastage?

580


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

875