LookUp Stage with just REJECT link
Posted: Tue Aug 29, 2017 8:43 am
Hi,
I am still on the learning phase in datastage and I have a doubt with datastage lookup stage.
I want to capture only the reject rows and I don't want to do anything with the correct matching rows.
I have a parallel job with a lookup stage that has input from a oracle connector and a reference also from oracle connector reading reords from different tables and comparing multiple keys. I made the constraint to Reject for lookup failure. I dragged the reject link to a transformer to process the records, but it gives a compilation error (Error : An unidentified error has occured) no other info.
If i connect both the output and the reject link, the flow compiles without error. But i dont need the matching records.
Is it normal that lookup does not support only the reject link ? May be in that case, is it better i write the sql query in the oracle conncetor instead of doing that using lookup.
I am still on the learning phase in datastage and I have a doubt with datastage lookup stage.
I want to capture only the reject rows and I don't want to do anything with the correct matching rows.
I have a parallel job with a lookup stage that has input from a oracle connector and a reference also from oracle connector reading reords from different tables and comparing multiple keys. I made the constraint to Reject for lookup failure. I dragged the reject link to a transformer to process the records, but it gives a compilation error (Error : An unidentified error has occured) no other info.
If i connect both the output and the reject link, the flow compiles without error. But i dont need the matching records.
Is it normal that lookup does not support only the reject link ? May be in that case, is it better i write the sql query in the oracle conncetor instead of doing that using lookup.