Interested to Buy Any Domain ? << Click Here >> for more details...
how u know when to use a static cache and dynamic cache in
lookup transformation.
- 9 Answers
- 27948 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / neetu arora
Dynamic cache is generally used when u are applying lookup
on a target table and in one flow same data is coming twice
for insertion or once for insertion and once for updation.
Performance: dynamic cache decreases the performance in
comparision to static cache since it first looks in the
whole table tht whether data ws previously present if no
thn only it inserts so it takes much tym
Static cache do not see such things just insert data as
many tyms as it is coming.
| Is This Answer Correct ? | 21 Yes | 1 No |
Post New Answer View All Answers
As union transformation gives UNION ALL output, how you will get the UNION output?
What is sorter transformation?
Scheduling properties,whats the default (sequential)
What are multi-group transformations?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is joiner change?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Explain pmcmd command usage in informatica
Clarify the aggregator change?
Define the various join types of joiner transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Explain the informatica workflow?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
