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
what is main difference between change capture and change apply stages
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?
what are the devoleper roles in real time? plz tell i am new to datastage....
Why we use surrogate key?
What is the difference between hashfile and sequential file?
What is the difference between operational data stage (ods) and data warehouse?
What are the difference types of stages?
How to manage date conversion in Datastage?
Explain usage analysis in datastage?
Explain datastage architecture?
Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2