how u know when to use a static cache and dynamic cache in
lookup transformation.
Answer Posted / nisith
Dear,
Whenever you required changes in your target as a lookup
than go for dynamic.Static means its a readonly why do u
want your server to busy..so stick on static only
comparison is there thats it....
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are the new features of informatica 9.x at the developer level?
explain abt ur project architecture?
What is the difference between Active and Passive transformation?
What are pre and post-session shell commands?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Explain joiner transformation in informatica
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is exclusive and normal mode for repository services?
Can you use flat files in Mapplets.
What is Index Caches size?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the differences between source qualifier and joiner transformation?
What does command task mean?
What are connected or unconnected transformations?