I have a requirement to look up with the target as it gets loaded.
i.e the records should get loaded in the target and then this should
act as reference to the source to pull the key from target to update an other field in target.
Now the job gets loaded with the empty field as their is no look up with the target.
please provide any input for this requirement.
Thanks
lookup with the target!!
Moderators: chulett, rschirm, roy
lookup with the target!!
Thanks,
Surya
Surya
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You seem to have stated the requirement quite well. I am presuming, of course, that your mapping specification correctly identifies the lookup key(s).
What you don't seem to have done is thought through the rule to be followed when the lookup does not succeed and when the lookup succeeds.
What you don't seem to have done is thought through the rule to be followed when the lookup does not succeed and when the lookup succeeds.
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.
Thank you
so do you mean do the lookup where it suceeds?
actually this is a kind of dynamic lookup.
The target needs to be loaded with an extra field which comes when we do lookup with the target itself.
So records should be loaded and also look up has to be done as they get loaded and the records which succeed look up should be loaded.
so do you mean do the lookup where it suceeds?
actually this is a kind of dynamic lookup.
The target needs to be loaded with an extra field which comes when we do lookup with the target itself.
So records should be loaded and also look up has to be done as they get loaded and the records which succeed look up should be loaded.
Thanks,
Surya
Surya
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What I mean by dynamic is a row should be inserted and then lookup with the source so that the primary key assigned to the inserted row is used as a parentkey to other records.
so that the table gets updated with the parentkey for all the records in the hierarchyexcept the top level.
I set array size to 1 in the oracle enterprise stage and also environmental variable
ORA_UPSERT_COMMITROWINTERVAL TO 1 but still the records are not
loaded with the parentkey.
Thank you
so that the table gets updated with the parentkey for all the records in the hierarchyexcept the top level.
I set array size to 1 in the oracle enterprise stage and also environmental variable
ORA_UPSERT_COMMITROWINTERVAL TO 1 but still the records are not
loaded with the parentkey.
Thank you
Thanks,
Surya
Surya