Data Stage Interview Questions
Questions Answers Views Company eMail

how to do pergformence tuning in datastage?

TCS, Symphony, MCA,

4 34482

what is the difference between datasatge and datastage TX?

6 22855

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

IBM,

7 13033




How can we run same job in 1 day 2 times

IBM,

4 11898

Wat is pre-load in Hashed file

Patni,

1 7450

How can we run same job in 1 day 2 times

IBM,

7 15402

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

DELL, IBM,

8 45301

tell me abt Datastage trigger?

IBM, HP,

1 16555




How do y read Sequential file from job control?

IBM, Telesis, HP,

2 11491

How do u call shellscript/Batch file from DS?

HP,

4 20866

What are the different database update actions available?

HP,

1 7466

Wat is isolation level and when do u use them?

IBM, HP,

1 17026

How do u view log file for a particular job?

HP,

6 19306

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

HP,

7 23613

How did you reconcile source with target?

HP,

2 7925


Post New Data Stage Questions






Un-Answered Questions { Data Stage }

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

1337


What are routines in datastage? Enlist various types of routines.

17


How do you remove duplicate values in datastage?

15


Lookup constraints

238


Name the different sorting methods in datastage.

10






if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

1163


What are data elements?

25


Difference between server jobs & parallel jobs?

20


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

39


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

1590


What are the job parameters?

30


Give an idea of system variables.

12


What are the stages in datastage?

13


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

1301


What is a quality stage?

19