Interested to Buy Any Domain ? << Click Here >> for more details...
What are the associated ports in look up T/R.
- 5 Answers
- 25522 Views
- IBM, Zensar, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Under which circumstances, informatica server creates reject files?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Why update strategy and union transformations are active?
explain about unit testing? in real time?
What is rank transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What are the uses of etl tools?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is workflow? What are the components of workflow manager?
Tell me about MD5 functions in informatica
What is rank index in rank transformation?
How can one identify whether mapping is correct or not without connecting session?
How we can use union transformation?
