Records are rejecting in Hash file

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
deva
Participant
Posts: 104
Joined: Fri Dec 29, 2006 1:54 pm

Records are rejecting in Hash file

Post by deva »

Hi
I have two flat files... I joined those two flat files using hash files. and two files have some constrains, I mention those constrains in transfarmer. when I try to run the job all records are rejecting.

Can any one advise me .

Thanks in advanse
mystuff
Premium Member
Premium Member
Posts: 200
Joined: Wed Apr 11, 2007 2:06 pm

Post by mystuff »

Can you specify more details.

a) What are you contraints that you are using (and where, you said in file as well)
b) I presume one of the files is not converted into hashed file (or is it?)
c) If possible can you show miniature diagram of your design.

The information in your earlier mail is not sufficient to suggest you much.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What is the output link execution order in your Transformer stage?

If the rejects link is first, then all rows will be "rejected", because the rejects link handles any row that has not been processed by an earlier-executed output link.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply