1.new record it will insert but changes of natural key
is not present in taget i want
to update (here key is composite natural key )can any one
help this to explan how to do


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Stage Interview Questions

How can we select pr retrieve the particular row in dataset by using orchadmin command?

1 Answers   IBM,


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...?

5 Answers   TCS,


how to sort two columns in single job in datastage.

1 Answers   TCS,


how can we create rank using datastage?what is the meaning of rank?

0 Answers   IBM,


Explain Quality stage?

0 Answers  






What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,


hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  


Define project in datastage?

0 Answers  


What is the difference between server job and parallel jobs?

0 Answers  


How to convert RGB Value to Hexadecimal values in datastage?

0 Answers  


how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,


Describe the main features of datastage?

0 Answers  


Categories