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
- 4798 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is informatica? Why do we need it?
Performance tuning in UNIX for informatica mappings?
Why update strategy and union transformations are active? Explain with examples.
 Code page compatibly –Where all changes are made to handle the scenario.
how to create user defined function (udf) in informatica
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
what is mean by grouping of condition column in lookup transformation?
what happens when a batch fails?
What does cheating measurement mean?
how to move the mappings from your local machine to claint place?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
What are the ETL tools available in DWH?
Teradata 
