Interested to Buy Any Domain ? << Click Here >> for more details...
What are the associated ports in look up T/R.
- 5 Answers
- 25472 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 |
In a table, 4 person having same salary. How to get Third person record only?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
Mention a few design and development best practices for informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Can we update a target table (without primarykey) by using update strategy transformation?
why we are using surogate key in real time give me explanation
In Which scenario did u used Incremental loading?
who to split dimentions into sub dimention
What are the active and passive transforamtions?
what is fact table?
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
Performance tuning in UNIX for informatica mappings?
Teradata 
