Interested to Buy Any Domain ? << Click Here >> for more details...
when do we use static cache and when do we use dynamic cache
in lookup transformation? with example.
- 1 Answers
- 4779 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
static cache is used when the records in the source does not update more frequently.
dynamic cache is used when the records in the source frequently updates.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Separate from a database, an information bazaar, and an information stockroom?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Which transformation is needed while using the Cobol sources as source definitions?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is meant by pre and post session shell command?
While migrating the data from one environment to another environment how would you manage the connections?
list out all the transformations which use cache?
Write the unconnected lookup syntax and how to return more than one column.
I have a flat file, want to reverse the contents of the flat file
Name the different lookup cache(s)?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Explain sessions. Explain how batches are used to combine executions?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Explain sessions and how many types of sessions are there?
