What are the associated ports in look up T/R.
Answer Posted / g. sunil kumar
Associate port is used to associate lookup columns with
input source columns to update the cache. The main
advantage we use dynamic lookup is to synch target with
lookup (let me know if it wrong), to synch both target and
lookup we used to insert/update. The question is to update
cache columns we have to associate respective cache columns
to source input columns as associate port. Some times you
may have pk in target/cache, for that column assoicate a
Sequence_id, which generate (pkcolumn max value)+1 value
for each inserts. It wil not generate sequence value for
update, assume if we generate value for it also.. data will
not in order. Hope this clear !
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How can you increase the performance in joiner transformation?
How to do unit testing in informatica? How to load data in informatica ?
How might one distinguish in the case of mapping is right or not without associating session?
How to partition the Session?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Informatica Checkpoints
Briefly define a session task?
Explain sql transformation in script mode examples in informatica
What are the new features of informatica 9.x developer?
Can you generate sequence numbers without using the sequence generator transformation?
How can we handle two sessions in informatica?
what is the hint? how to use it to reduce the query processing in program?
What are the modules in Power Center
Explain the tuning lookup transformation - informatica
What is option by which we can run all the sessions in a batch simultaneously?