Data Stage Interview Questions
Questions Answers Views Company eMail

how to do pergformence tuning in datastage?

MCA, Symphony, TCS,

4 41064

what is the difference between datasatge and datastage TX?

6 27515

What is exact difference between Parallel Jobs and server Jobs..

IBM,

7 17566

How can we run same job in 1 day 2 times

IBM,

4 15992

Wat is pre-load in Hashed file

Patni,

1 9130

How can we run same job in 1 day 2 times

IBM,

7 20666

What is exact difference between Parallel Jobs and server Jobs..

DELL, IBM,

8 57076

tell me abt Datastage trigger?

HP, IBM,

1 18994

How do y read Sequential file from job control?

HP, IBM, Telesis,

2 14430

How do u call shellscript/Batch file from DS?

HP,

4 24952

What are the different database update actions available?

HP,

1 9196

Wat is isolation level and when do u use them?

HP, IBM,

1 19816

How do u view log file for a particular job?

HP,

6 23167

How do u set a default value to a column if the column value is NULL?

HP,

7 32913

How did you reconcile source with target?

HP,

2 10485


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the purpose of pivot stage and types of containers in datastage

619


Differentiate between datastage and datastage tx?

603


Can you filter data in hashed file?

3355


sed,awk,head

976


If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1642






what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2187


How will you move hashed file from one location to another location?

1663


I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

554


Why do we use exception activity in Datastage?

732


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1638


Explain Quality stage?

673


What are the components of ascential data stage?

656


1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3509


What is the difference between an operational datastage and a data warehouse?

642


What are the types of containers and how to create them?

562