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
What is the meaning of decode in informatica?
what is the hint? how to use it to reduce the query processing in program?
What are different types of transformations available in informatica?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
State the differences between sql override and lookup override?
What does role playing dimension mean?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What can we do to improve the performance of informatica aggregator transformation?
Is stop and abort are same in informatica?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Clarify the aggregator change?
What is meant by target load plan?
Briefly explain the aggregator transformation?
What is an expression transformation in informatica?
How we can create indexes after completing the load process?