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
- 6588 Views
- I also Faced
- E-Mail Answers
Answer Posted / santosh kumar sarangi
Hi Urs, as you told, if record exit then it will update so
can you please clarify which one it will update cache or
target table. If it will update the target table the why we
need the update strategy T/R.
In my view, if any things updating in the dynamic look up
cache then it's responsibility of developer to update the
same in the target, other wise look up cache and target will
not be in sync,
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How to do the error handling of if ur source is flatfiles?
waht type of interface is used for testing the data in informatica
What is depict expression change?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is olap (on-line analytical processing?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What does cheating measurement mean?
Differentiate between a repository server and a powerhouse?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Enlist the tasks for which source qualifier transformation is used.
What is a sequence generator transformation?
What are ETL Tools?
how we can load rejected record's at run time?(not through bad files)
Tell me about MD5 functions in informatica
