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 |
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
What aer the out put files that the informatica server creates during the session running?
How many ways are there to do 'remove duplicate records in informatica'?
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
how to get max value record into one target and remaining records into another target?
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
What is a stored procedure transformation?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.