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 / 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
Differentiate between Load Manager and DTM?
list out all the transformations which use cache?
Can we create a node as a gateway node and the same node can be assigned to a grid?
tell me 5 session failure in real time how can you solve that in your project?
Explain in detail about scd type 1 through mapping.
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a pre-defined event and user-defined event?
Explain how many types of dimensions are available in informatica?
What is the cumulative sum and moving sum?
What is olap (on-line analytical processing?
What is joiner transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Explain what are the different types of transformation available 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?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?