less rows from lookup

DSRajesh · Post by **DSRajesh** » Thu Aug 09, 2007 6:40 pm

can any one help here pls

ArndW · Post by **ArndW** » Thu Aug 09, 2007 7:57 pm

DSRajesh - so many people have tried to help in this thread, and opened up a number of questions which you haven't answered or addressed, so there is little incentive for anyone to do more on the problem until you've done a bit of work on it as well.

You now have a case where a write to sequential give more rows than a write to a hashed file and you have gotten messages about using multiple keys and key contents.

hemachandra.m · Post by **hemachandra.m** » Fri Aug 10, 2007 12:34 am

Were you able to view thw data atleast.

hemachandra.m · Post by **hemachandra.m** » Fri Aug 10, 2007 12:39 am

If you are not using a transformer in between the Oracle & Lookup stage, then have a transformer and try it.

Raghavendra · Post by **Raghavendra** » Fri Aug 10, 2007 1:04 am

DSRajesh wrote:Hi hema,

I had totally 4 coulmns in my table where first 3 columns are hey columns and the last column which is not key column is missing the data in hash file where the row exists in database .

tried in many ways but in vain.

pls help me here

Might be a crazy question. Can you check if the order of columns you mentioned in the hashfile and the order of columns you are mapping from your transformer are same.