Find the Rejected data from which source

[malladi_555]

Hey i got a small confusion about the topic...can anybody suggest about this....

Our source is DB2..we are in the kinda data integration project...

we have 4 source tables..get those into 2 SIF(Standard Interface File)structure..after doing the sif structure we do the load ready jobs(Kinda business transaction jobs)..But the thing we wan't to handle the rejects at load ready jobs stage...if we will collect the rejects over there and send it to client then he might not understand the reject data is coming from which source table to fix it...we had a taught of getting flags for each source table and find it through flags..but there is a problem with it...if we are doing the joins at sif stage then there will be a problem with those kind of stuff....any suggestions Welcome.....

[tbharathkumar]

Introduce alias column like Source_table while selecting data from source, use the same as identifier in reject data.