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 / chandrasekar
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 |
Post New Answer View All Answers
r u done any partitions in ur project?
Can we create a Integration service without a Repository service and vice versa?
What is a rank transform?
What are roles and groups and benefits of using them?
How to elaborate powercenter integration service?
What is aggregate cache in aggregator transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to load a Dimension ? and how to load a fact table?
In development project what is the process to follow for an etl developer from day1
How might one distinguish in the case of mapping is right or not without associating session?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How do we call shell scripts from informatica?
How do you convert single row from source into three rows into target?