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 ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
IF THE LOOKUP CONDITION IS TRUE THEN THE RECORD IS LOADED IN
CACHE AS WELL AS IN TARGET BUT THE TARGET FAILED MEANS
RECORD ONLY LOADED IN CACHE.
IF IT IS WRONG MEANS PLEASE MAIL ME chandranmca2007@gamil.com
| Is This Answer Correct ? | 1 Yes | 4 No |
What are the different types of Type2 dimension maping?
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
in realtime which situations u can use unconnected lookup transformation
What are the advantages of informatica?
Write the unconnected lookup syntax?
what is the necessity to use update strategy?(except for updates)
what is pre and post sql and what is diff between source presql and target pre sql
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
How many number of sessions can one group in batches?
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
Under which circumstances, informatica server creates reject files?
Can we change Dynamic to Static or Persistent cache? If so what happens?