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
to collect rejects while joining to files
Moderators: chulett, rschirm, roy
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.