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
- 21422 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
Explain the different dimensions.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
what is song in infrmatica...?
Explain your project of banking domian.
Explain sql transformation in script mode examples in informatica
What is native users?
can u any challenge your project?
Define pmcmd command?
What is meant by active and passive transformation?
What is informatica etl tool?
What is the use of transformation?
What is a surrogate key?
What you know about transaction control transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is the difference between writing a joiner query in ANSI style and THETA style?
