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
What is a repository? And how to add it in an informatica client?
What is the use of transformation?
can u give example for factless fact table
What is substr in informatica?
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
Informatica Checkpoints
Explain the features of connected and unconnected lookup.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
what is the Default Source Option For Update Strategy Transformation?
Explain the informatica workflow?
Which files are created during the session rums by informatics server?
Target increases every day even though no new record was inserted
Why filter transformation is an active one?
What do you mean incremental aggregation?
Write the program through which the records can be updated?