What are the associated ports in look up T/R.

Answers were Sorted based on User's Feedback



What are the associated ports in look up T/R...

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

What are the associated ports in look up T/R...

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

What are the associated ports in look up T/R...

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

What are the associated ports in look up T/R...

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

What are the associated ports in look up T/R...

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

Post New Answer

More Informatica Interview Questions

How to delete duplicate records in a flat file source?

2 Answers  


What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,


How to merge First Name & Last Name?

8 Answers  


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.

0 Answers   Informatica,


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  






Write the advantages of partitioning a session?

0 Answers  


How do you create single lookup transformation using multiple tables?

6 Answers   TCS,


What is parameter file?

2 Answers  


What is the use of an aggregator cache file?

0 Answers  


How many cubes create from a single model?

1 Answers  


What are the data movement modes in informatica?

0 Answers   Informatica,


hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,


Categories