Interested to Buy Any Domain ? << Click Here >> for more details...
If I have set the property Treat Source Rows as Insert and
for the target properties I have checked the boxes Update as
Update, what will happen to incoming rows?
What exactly is the use of these check boxes and in which
scenarios we use them. Also what is the sequence in which
informatica understands these properties.Does it takes
whatever is defined in treat source rows as property or it
is in any other way. Please explain.
- 3 Answers
- 21284 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / sandeep
(Q) If I have set the property Treat Source Rows as Insert
and for the target properties I have checked the boxes
Update as Update, what will happen to incoming rows?
Answer:
- When you set propery Treat source rows as Insert and also
checked Insert in target properties then IS will treat all
source rows as inserts.
- If you miss to check insert option in target properties,
all the source records will be rejected.
- If at all you also set properties like update and delete
along with insert in target properties, it will ignore
update & delete options and treat source rows as inserts.
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
What is informatica etl tool?
What is DR strategy for Informatica project?
What are the types of caches in lookup? Explain them.
How to extract sap data using informatica?
How to convert multiple rows to single row (multiple columns) in informatica
is it possible to index the data in cache of lkp transformation ?
How to join three sources using joiner?
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,
What does cheating measurement mean?
Performance tuning in UNIX for informatica mappings?
what is the Default Source Option For Update Strategy Transformation?
How to create Target definition for flat files?
What is rank transformation in informatica
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is complex mapping?
