what is target update override and when we use it?
Answer Posted / moorthy g
Whenever the source table have non key columns but I want to
update in the target table then you have to go for target
update override.
Target Properties - Update Override - give some update
condition.
Correct me If I'm wrong
Thanks
Moorthy
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
Define the various join types of joiner transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is meant by a domain?
What is powercenter on grid?
What is persistent lookup cache?
What is sorter transformation?
What do you understand by a term domain?
expain about the tune parameters?
What is the advantage of informatica?
How would you join a node to the already existing domain?
How we can create indexes after completing the load process?
How you can differentiate between connected lookup and unconnected lookup?
Enlist the tasks for which source qualifier transformation is used.