Constraints Rejects and Filtered records
Posted: Tue Jan 23, 2007 3:13 am
Hi,
I have a transformer where i basically join 2 different tables from different source. I need to somehow capture the Rejected records and the Filtered records at the same time without additional constraint in the transformer. An example will make it clear
I Have Table A from source1 and Table B from Source2. In the transfomer i have the following constraint
a.Cust_id = b.Cust_id
Now i need the following output
1. Cust_id's which has satisfied the condition
2. Cust_id's which has not satisfied the condtition(without constraint a.cust_id != b.cust_id)
3. Any records that are rejected due to some errors(the job shouldnt fail..but have to capture these error records)
Thanks in advance
Raj
I have a transformer where i basically join 2 different tables from different source. I need to somehow capture the Rejected records and the Filtered records at the same time without additional constraint in the transformer. An example will make it clear
I Have Table A from source1 and Table B from Source2. In the transfomer i have the following constraint
a.Cust_id = b.Cust_id
Now i need the following output
1. Cust_id's which has satisfied the condition
2. Cust_id's which has not satisfied the condtition(without constraint a.cust_id != b.cust_id)
3. Any records that are rejected due to some errors(the job shouldnt fail..but have to capture these error records)
Thanks in advance
Raj