What are the different caches used in informatica?
Answers were Sorted based on User's Feedback
Answer / ajay
which cache u whant
for this question there so many caches are there
1)look up cache
i) static cache
ii) dynamic cache
iii)shared cache
iV) persistent
2) joiner cache
3) aggregater
4) rank
and al so data cache and index cache ok
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / munireddy
static cache
dynamic cache
shared cache
and persistent cache....
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / rajan raorane
Persistent cache
Recache
Static Cache
Dynamic cache
shared cache
Is This Answer Correct ? | 3 Yes | 0 No |
What are mapplets? How is it different from a Reusable Transformation?
I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....
how can you load data into target table without leading zeor's
Mention a few design and development best practices for informatica?
can you use flat file for lookup table?why?
tell me about your project functionality
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 A complex mapping?
What are the mapping paramaters and mapping variables?
which quality process u can approach in ur project
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
What do you mean incremental aggregation?