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?
Answer Posted / subhash
SeqFile1----->|
.................|ChangeCapture--->Transformer--->TGT
SeqFile2----->|
SeqFile1 & SeqFile2 are the inputs to Change Capture.
From the output Change Capture Stage we one extra column
‘Change Code’.
If, the record is same in both file, i.e. Copy Record.
Change Code=0
If, the record is only in SeqFile1, i.e. insert Record.
Change Code=1
If, the record is only in SeqFile2, i.e. delete Record.
Change Code=2
If, the record is in both files but with some modifications,
i.e. edit/update Record. Change Code=3
If all Change are '0' then 2 files having same Data.
In the transformer constraints, we can mention as ‘ change
code <>0’ then set ‘Abort After Rows’ to ‘1’.
Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What is the process of killing a job in datastage?
Which commands are used to import and export the datastage jobs?
What is the difference between hashfile and sequential file?
What are the some differences between 7.x and 8.x version of datastage?
What is ibm datastage flow designer?
What is the flow of loading data into fact & dimensional tables?
How many types of stage?
To see hidden files in LINIX?
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
describe the Steps to confiure a Qlogic switch
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are the different layers in the information server architecture?
Differentiate between datastage and informatica?
How do you run datastage job from the command line?