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?
- 1 Answers
- 6874 Views
- IBM, I also Faced
- E-Mail Answers
Answer / rahul verma
We need to compare the two source data using Change Data
Capture stage. If the Change_code is '0' then there are no
differences between the two sources. If the value of
Change_code is "1" or "2" or "3" then all the data in two
sources are not same.
To abort the job in case of any discrepancies between two
sources, we can make use of a Transformer stage wherein we
can provide the condition for CHange_code <>0, this will
pass the unmatched record to next stage.Since we need to
abort the job, in the same transformer derivation - check
the abort box and mention row = 1, which will result in as
soon as any unmatched record leaves this transfomer stage,
the job aborts. Hence serve the purpose.
Kindly comment on my resolution and pls correct me in case
i am wrong.
| Is This Answer Correct ? | 9 Yes | 1 No |
Why we use surrogate key?
Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S
Nls stands for what in datastage?
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
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?
How to Convert a string function to date function by using only sequential file stage with out using other stages ?
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?
Define data aggregation?
Difference between in process and inter process?
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
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
Teradata 
