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
- 27555 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / nitin
I have a major doubt in static and dynamic cache.
1. what is the use of both?
2. while using dynamic cache(looking up target table),say a record is entering from source emp_id = 101, which is already in the target so this will be updated am i correct?
3. while using a static cache, same scenario as above the record also gets updated.
4. what happens in both the caches, when again a same record enters from the source
5. when will the record be rejected as a duplicate?
from my understanding, while using a static cache for already existing record in target. when a same record appears twice from source then the record that is appearing second time will be rejected as a duplicate. but in dyanmic cache it will not?.. is this true?
Please help me understand when the record will be rejected as a duplicate and when it will be updated, in case of dynamic and static cache
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a sorter transformation?
When do you use sql override in a lookup transformation?
How does a rank transform differ from aggregator transform functions max and min?
Difference between Data and Index Caches?
What is the function of union transformation?
Can we get 1st record through Informatica(without sequence number).
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Describe the impact of several join conditions and join order in a joiner transformation?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
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.
How can you define user defied event?
What are roles and groups and benefits of using them?
What is a surrogate key?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
what is $$$$?
