Data Stage Interview Questions
Questions Answers Views Company eMail

how to do pergformence tuning in datastage?

MCA, Symphony, TCS,

4 40959

what is the difference between datasatge and datastage TX?

6 27421

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

IBM,

7 17467

How can we run same job in 1 day 2 times

IBM,

4 15909

Wat is pre-load in Hashed file

Patni,

1 9099

How can we run same job in 1 day 2 times

IBM,

7 20571

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

DELL, IBM,

8 56954

tell me abt Datastage trigger?

HP, IBM,

1 18960

How do y read Sequential file from job control?

HP, IBM, Telesis,

2 14390

How do u call shellscript/Batch file from DS?

HP,

4 24872

What are the different database update actions available?

HP,

1 9175

Wat is isolation level and when do u use them?

HP, IBM,

1 19779

How do u view log file for a particular job?

HP,

6 23086

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

HP,

7 32785

How did you reconcile source with target?

HP,

2 10445


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Triggers,VIEW,Procedures

789


Differentiate between data file and descriptor file?

610


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3365


What is a merge in datastage?

759


Explain the situation where you have applied SCD in your project?

1553






How do you import and export the datastage jobs?

729


How complex jobs are implemented in datstage to improve performance?

585


What are stage variables?

628


What is the difference between informatica and datastage?

649


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.

3493


What is process model?

1543


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?

2045


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1888


What is the difference between server job and parallel jobs?

658


What are the different kinds of views available in a datastage director?

591