Data Stage Interview Questions
Questions Answers Views Company eMail

how to do pergformence tuning in datastage?

TCS, Symphony, MCA,

4 25263

what is the difference between datasatge and datastage TX?

6 16348

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

IBM,

7 7491

How can we run same job in 1 day 2 times

IBM,

4 6436

Wat is pre-load in Hashed file

Patni,

1 4894

How can we run same job in 1 day 2 times

IBM,

6 9761

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

DELL, IBM,

8 28474

tell me abt Datastage trigger?

IBM, HP,

1 10866

How do y read Sequential file from job control?

IBM, Telesis, HP,

2 7249

How do u call shellscript/Batch file from DS?

HP,

4 14371

What are the different database update actions available?

HP,

1 4846

Wat is isolation level and when do u use them?

IBM, HP,

1 11614

How do u view log file for a particular job?

HP,

6 13445

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

HP,

7 15493

How did you reconcile source with target?

HP,

2 4209


Post New Data Stage Questions


Un-Answered Questions { Data Stage }

On which Dimension Table you implemented SCD Type in your Project

533


i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

664


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

1601


How do you design PX Routines ?

588


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

633


what is the use of skid in reporting?

557


What are the partitioning techniques available in link partitioner?

453


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

1396


what is the use of surogate key in datastage

547


Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

667


root tree will find which is server job and which is parallel job?

367


Can we use target hash file as a lookup ?

793


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

702


Sorce contins the metadata sorce ----- hyderabad,chennai,banglore by using nested loop sequence select sourch as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

718


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

590