to collect rejects while joining to files

Edwink · Post by **Edwink** » Mon Sep 18, 2006 8:48 am

hi,
i m joing two files there are some rejects i need to take the count of reject files ..can any one help me how to get thet count
Thanks in advance
Edi

Woth · Post by **Woth** » Mon Sep 18, 2006 9:21 am

Hi,
Not having much information about the stages you are using, here is a simple idea.
You could use a stage variable in the transformer stage. Have it output it once when the job is completed (either in a seperate sequential file or any other way you wish). In that file, you could have 2 columns -- number rejected and number validated

simple idea -- might do the job.

DSguru2B · Post by **DSguru2B** » Mon Sep 18, 2006 10:08 am

or just do it at the unix level by using the wc -l command

kumar_s · Post by **kumar_s** » Mon Sep 18, 2006 6:03 pm

If you want to produce a report of the rejected rows, you can either opt for the dsjob -linkinfor or DSLinkInfo.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 18, 2006 6:32 pm

What, precisely, do you mean by "rejected" rows? A join by definition does not generated reject rows. It simply generates the result of the join.

Edwink · Post by **Edwink** » Wed Sep 20, 2006 5:17 am

friends,
i need to collect the unmatch records while joining two files... and i m using merge stage for joining..since i need to take report on joining i need both matched record count as well unmached...
thanks :D

ray.wurlod · Post by **ray.wurlod** » Wed Sep 20, 2006 3:03 pm

The Match stage does not have this functionality.

Ask yourself how you would do it with a pair of database tables? The join just gives you the matched rows; the others do not appear unless you create a second query.

Then figure out how to do it with DataStage. Merge stage is not the solution, since it can only perform an equi-join.