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?
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 |
Notification Activity
How many Nodes configuration file you used in your last project?
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
How can we improve the performance in datastage?
Wat is isolation level and when do u use them?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
What are the different common services in datastage?
How can we select pr retrieve the particular row in dataset by using orchadmin command?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls
What are stage variables, derivations and constants?
What is the difference between account and directory options ?