What are the associated ports in look up T/R.
Answers were Sorted based on User's Feedback
Answer / ravi
when we are using dynamic cache the associated port will be
enabled which is used to update or insert to the cache
Is This Answer Correct ? | 23 Yes | 2 No |
Answer / 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 |
Answer / sivak
by using associated port we can generate sequence numbers
with out using sequence generator t/r.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / vicky yadav
when we are using dynamic cache the associated port will be
enabled which is used to update or insert to the cache.The
question is to update
cache columns we have to associate respective cache columns
to source input columns as associate port
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / achari
Using associate port in Dynamic lookup Transformation, we can do insert or update the cache in lookup.
Is This Answer Correct ? | 1 Yes | 1 No |
How to delete duplicate records in a flat file source?
What's the layout of parameter file (what does a parameter file contain?)?
How to merge First Name & Last Name?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Write the advantages of partitioning a session?
How do you create single lookup transformation using multiple tables?
What is parameter file?
What is the use of an aggregator cache file?
How many cubes create from a single model?
What are the data movement modes in informatica?
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.