DSXchange

Hi All,

How can we trap the reject records in Join.


Thanks in advance.

Hi Pravin,

Use Merge stage instead of Join stage. The reject link in merge stage gives all the rejected records.

sureshabbisetti wrote:Hi Pravin,

Use Merge stage instead of Join stage. The reject link in merge stage gives all the rejected records.

But the requirement is to use the Join stage,as it gives the join types which we donot get in merge.

You requirement is to trap reject records using a JOIN stage? What kind of a join are you doing?

Does the requirement ask you to *use* a join stage?

State your requirement clearly, that would help others help you :D

Minhajuddin wrote:Does the requirement ask you to *use* a join stage?

State your requirement clearly, that would help others help you :D

Yes thats right.

Do you want records which don't have a match in the join in the rejected records?

If so, you can use a left outer join(by properly ordering the links) and in a downstream transformer you can check if a not nullable column(you should pass a not nullable column to the output from the right link in the join, also you should change the nullable property to YES) from the right link. If the not nullable column is null you can send it to a file (this would be your reject link)

Minhajuddin wrote:Do you want records which don't have a match in the join in the rejected records?

If so, you can use a left outer join(by properly ordering the links) and in a downstream transformer you can check if a not nullable column(you should pass a not nullable column to the output from the right link in the join, also you should change the nullable property to YES) from the right link. If the not nullable column is null you can send it to a file (this would be your reject link)

Try to use full outer and find the key column which is null on the reference to filter out after the join

A Join does not generate any "rejects", either in SQL or in DataStage.

The merge is only can be used when there is one -to -one relation ship.

[quote="ray.wurlod"]A Join does not generate any "rejects", either in SQL or in DataStage.[/quote] Ab Initio does though!

strange requirement. without knowing the tools limitation.

if your requirement is to capture the records which does not fulfill the join criteria, then use full outer join in then in a filter or transformer stage, check the null values from the child link