Answer Posted / mohanreddybank
There are different caches we have in informatica
Static, dynamic,persistent,shared lookup cache
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are Dimensional table?
Difference between Target-based loading and constraint-based loading?
Explain load alternative records / rows into multiple targets - informatica
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What are the components of the workflow manager?
How to do the error handling of if ur source is flatfiles?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is meant by target load plan?
how to load rows into fact table in data warehouse
What is the use of code page?
Explain sessions and how many types of sessions are there?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
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?