Interested to Buy Any Domain ? << Click Here >> for more details...
What are the associated ports in look up T/R.
- 5 Answers
- 25377 Views
- IBM, Zensar, I also Faced
- E-Mail Answers
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 |
Can you access a repository created in previous version of Informatica?
What is a standalone command task?
How to extract the informatica rejected data?
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
what is the difference between lookupoveride and joiner?
Which kind of index is preferred in DWH?
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
What are the designer tools for creating tranformations?
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
Teradata 
