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 ?
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
How we can create indexes after completing the loan process?
waht type of interface is used for testing the data in informatica
What is lookup change?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is the difference between stop and abort in informatica
Differentiate between a database and data warehouse?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Sequence generator, when you move from develoment to production how will you reset
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
update strategy transformation in informatica
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Design a mapping to load a target table with the following values from the above source?
How many ways are there to do 'remove duplicate records in informatica'?
What do you mean by filter transformation?
What are the uses of etl tools?