Interested to Buy Any Domain ? << Click Here >> for more details...
What are the associated ports in look up T/R.
- 5 Answers
- 25619 Views
- IBM, Zensar, I also Faced
- E-Mail Answers
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
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How many dimensions are there in informatica?
What is decode in static cache?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the function of look up transformation?
What is the function of aggregator transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How to generate or load values in to the target table based on a column value using informatica etl tool.
what is the complex transformation you used in informatica
What are the types of schemas we have in data warehouse and what are the difference between them?
What is meant by pre and post session shell command?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the new features of informatica 9.x at the developer level?
