Hi,
I have say 1000 records in the source and when looked up against a hash it matches only 200. Now, I should load 1000 into target instead of 200
Here for one field I get the value from the lookup
i.e. 200 records with values for the lookup field from the hash file and for the rest 800 records the field should contain null
I have a problem like it loads only 200 since I am getting values from hash also. Any suggestion pls
Regards
Target Load issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is no Join stage in server jobs.
From your description I believe you have a constraint expression in your Transformer stage that is only allowing rows to be output where the lookup succeeded.
Another possibility is that you are delivering NULL to a column that is defined as NOT NULL in the target database. In this case there should be warnings in the job log.
From your description I believe you have a constraint expression in your Transformer stage that is only allowing rows to be output where the lookup succeeded.
Another possibility is that you are delivering NULL to a column that is defined as NOT NULL in the target database. In this case there should be warnings in the job log.
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.