suppose we are using dynamic lookup cache and in lookup
condition the record is succeeded but in target it is failed
due to some reasons then what happened in the cache ?
- 3 Answers
- 6601 Views
- I also Faced
- E-Mail Answers
Answer Posted / urs
When we are using the lookup cache as dynamic at first run
it will stores the all lookup table records into the cache
but second run it will check whether the incoming source
record having in the target table or not..if the record
exist in target table it will update otherwise it will
insert..this load type is done based on your condition
...nothing will happen in cache..
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Briefly define a session task?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is transformation?
What is informatica? Why do we need it?
What are the types of caches in lookup? Explain them.
What is meant by a domain?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How can we handle two sessions in informatica?
Differences between connected and unconnected lookup?
To import the flat file definition into the designer where should the flat file be placed?
hi real timers . iam waiting for ur reply regarding ETL TESTING
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain sessions. Explain how batches are used to combine executions?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
