Data Stage Interview Questions
Questions Answers Views Company eMail

how to do pergformence tuning in datastage?

TCS, Symphony, MCA,

4 32264

what is the difference between datasatge and datastage TX?

6 21467

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

IBM,

7 11590




How can we run same job in 1 day 2 times

IBM,

4 10623

Wat is pre-load in Hashed file

Patni,

1 6807

How can we run same job in 1 day 2 times

IBM,

7 13798

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

DELL, IBM,

8 41267

tell me abt Datastage trigger?

IBM, HP,

1 15212




How do y read Sequential file from job control?

IBM, Telesis, HP,

2 10419

How do u call shellscript/Batch file from DS?

HP,

4 19454

What are the different database update actions available?

HP,

1 6835

Wat is isolation level and when do u use them?

IBM, HP,

1 15921

How do u view log file for a particular job?

HP,

6 18048

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

HP,

7 21266

How did you reconcile source with target?

HP,

2 7045


Post New Data Stage Questions






Un-Answered Questions { Data Stage }

Is possible to create skid in dim,fact tables?

904


table actions available in oracle connector?

230


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

716


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?

984


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

2417






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

1022


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1052


How you Implemented SCD Type 1 & Type 2 in your project?

2791


How to reverse the string using unix?

197


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 ?

849


What is process model?

724


why do u need the IOS upgradation in a FC switch

1066


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

247


what are the devoleper roles in real time? plz tell i am new to datastage....

815


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

875