| Other Data Stage Interview Questions |
|| Asked @
|What is the default execution order of the sequential file?
|what is the use of surogate key in datastage
|LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?
|What is PX?
|how can you generate sequence number using only the sequential
|what is initial load and incremental load
|I am having two tables called MASTER and DETAIL. I want to
insert records to both tables. But one condition is that
whenever the insert for MASTER table is success then only
the records will inserted into the DETAIL table, otherwise
abort the job. How can u design this job?
|How to write a left outer join condition by using
Transformer stage in server jobs?
Could any one help me?
|How can we do null handling in sequential files
|what is the definitions for Datawarehose and Datamart?
|i have seq file that contents 10 million records load to target any data base..
in that case it takes lot of time for loading..how do performance tuning in that situation...?
|how can i get 2nd highest salary in datastage?can u send me
2)if i had source has 2 records 1st record ie 1st column
contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to
get target as 2nd columns as 20,30,40 how can i?
|For more Data Stage Interview Questions Click Here |