Data Stage Interview Questions
Questions Answers Views Company eMail

how to do pergformence tuning in datastage?

TCS, Symphony, MCA,

4 25985

what is the difference between datasatge and datastage TX?

6 16945

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

IBM,

7 7755

How can we run same job in 1 day 2 times

IBM,

4 6734

Wat is pre-load in Hashed file

Patni,

1 5068

How can we run same job in 1 day 2 times

IBM,

6 10111

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

DELL, IBM,

8 29934

tell me abt Datastage trigger?

IBM, HP,

1 11264

How do y read Sequential file from job control?

IBM, Telesis, HP,

2 7501

How do u call shellscript/Batch file from DS?

HP,

4 14975

What are the different database update actions available?

HP,

1 5048

Wat is isolation level and when do u use them?

IBM, HP,

1 12205

How do u view log file for a particular job?

HP,

6 13953

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

HP,

7 16130

How did you reconcile source with target?

HP,

2 4502


Post New Data Stage Questions


Un-Answered Questions { Data Stage }

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

645


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

1606


how to abort the job its matain duplicates?

769


project Steps,hits, Project level HArd things,Solved methods?

628


On which Dimension Table you implemented SCD Type in your Project

555


What are the partitioning techniques available in link partitioner?

472


what is the use of surogate key in datastage

555


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

380


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 ?

572


Can you filter data in hashed file?

1722


Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

1344


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

612


why do u need the IOS upgradation in a FC switch

757


what is use of SDR function?

2856


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

1104