1.why we need to use unconnected transformation?
2.where we can static chach,dynamic chach
Answer Posted / rahul
In Lookup transformation;
Unconencted is used when ever u want to call the same
transformation several times and u have one return port.
Use dynamic cache if u want to update the case while
updating the target table itself and static is untouched
with the cache.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Define filter transformation?
How can we delete duplicate rows from flat files?
How to load the data from people soft hrm to people soft erm using informatica?
How to delete duplicate row using informatica?
Under what condition selecting sorted input in aggregator may fail the session?
Where are the source flat files kept before running the session?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How you know when to use a static cache and dynamic cache in lookup transformation?
what is the Default Source Option For Update Strategy Transformation?
How to do unit testing in informatica? How to load data in informatica ?
Explain what transformation and how many are there in informatica?
Can we create a Integration service without a Repository service and vice versa?
What is the function of look up transformation?
Explain the types of transformations?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?