What are the associated ports in look up T/R.
- 5 Answers
- 23655 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 |
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
What are the types of presistent cache in look up tr.
Why the workflow is failed after running two hours in informatica?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
Tell me about informatica architecture.
wht is full process of Information source to target just like stg to productuon and development
why we use source qualifier transformation?
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?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
how much memory (size) occupied by a session at runtime
in oracle write query yourname+1 from dual
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
Teradata 
