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
What are the types of data warehouses?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain lookup transformation source types in informatica
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is aggregate cache in aggregator transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are active transformations.
How do you update the records with or without using update strategy?
where to store informatica rejected data? How to extract the informatica rejected data?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is sorter transformation?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
what is the hint? how to use it to reduce the query processing in program?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
EXL informatica Questions