My Job design is,
Oracle------>Transformer------>HashFile
There are 100 records in source however only 50 records are loading into hash file. The performance statistics show 100 records loaded into hash file however only 50 records are there in the hash file. I checked the log and no warning or errors.
Performance statistics are like this.
ODBC---100 Rows--->Transformer----100 Rows-->Hash
replaced the Hash file with Sequential file and all records are loading no problem.
What is the cause for this???????
I need to use hash file as target because in a follow up job I am looking up this hash file. So I would like all these records to be available for the lookup of the hash file in the transformer coming from the reference link.
-Vetti
All records not loading into hash file
Moderators: chulett, rschirm, roy
Then you need to use a stage that allows a 'multi-row result set' which means either the UV or ODBC stages. The former is a bit of a pain to setup and use so I'd suggest the latter set to lookup directly against the (apparently small) source table rather than trying to build an intermediate data set.
Perhaps they've relaxed this 'restriction' and allow that option multi-row on more stages... can anyone confirm / deny?
Perhaps they've relaxed this 'restriction' and allow that option multi-row on more stages... can anyone confirm / deny?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: