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.
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
How do you convert single row from source into three rows into target?
can u any challenge your project?
list out all the transformations which use cache?
Can informatica load heterogeneous targets from heterogeneous sources?
Enlist the differences between database and data warehouse.
what is the hint? how to use it to reduce the query processing in program?
What are the new features of informatica 9.x at the developer level?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Why update strategy and union transformations are active? Explain with examples.
Explain in detail scd type 2 through mapping.
Which transformation is needed while using the Cobol sources as source definitions?
What are the tasks that source qualifier perform?
design of staging area?
Define update strategy?
How to join three sources using joiner? Explain though mapping flow.