Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7241 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
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How to improve the performance of a session using sorter transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is aggregator transformation in informatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to extract the informatica rejected data?
Design a mapping to load a target table with the following values from the above source?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Why do we need informatica?
Clarify the aggregator change?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is target load order?
What are the different ways to implement parallel processing in informatica?
How do you load first and last records into target table?
What is a filter transformation and why it is an active one?
