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
- 7073 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
How can we remove the duplicates from flat file source?
Enlist the differences between database and data warehouse.
What is a standalone command task?
If informatica has its scheduler why using third party scheduler?
What are the databases that informatica can connect to windows?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Briefly define a session task?
Why sorter is an active transformation?
can u any challenge your project?
Is stop and abort are same in informatica?
How do you migrate data from one environment to another?
What are data-driven sessions?
What are the types of data warehouses?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
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
