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
- 21268 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 the commit type if you have a transaction control transformation in the mapping?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How to improve the performance of a session using sorter transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is a sorter transformation?
EXL informatica Questions
Explain in detail scd type 2 through mapping.
What is the meaning of decode in informatica?
What is mapplet in informatica?
What is a node in Informatica?
Write the different tools in the workflow manager?
What is workflow monitor?
How do you load only null records into target? Explain through mapping flow.
Whats the difference between informatica powercenter server, repositoryserver and repository?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
