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
- 21134 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 mean by complex business rule ?
Why do you use Mapping Parameter and mapping variable?
Write the different tools in the workflow manager?
What are multi-group transformations?
Can anyone tell me the new features in Informatica 9 Version?
Scheduling properties,whats the default (sequential)
What are the new features of informatica 9.x developer?
What is rank transformation in informatica
What is confirmed fact in dataware housing?
Explain Dataware house architecture .how data flow from intial to end?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Do you find any difficulty while working with flat files as source and target?
How we can create indexes after completing the load process?
What is a repository? And how to add it in an informatica client?
How can we store previous session logs?
