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
- 21255 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
Separate from an archive server and a powerhouse?
Can anyone tell me the new features in Informatica 9 Version?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How do you convert single row from source into three rows into target?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
define galaxy repository in informatica
Can we create two repositories on same database instance in oracle?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Differentiate between joiner and lookup transformation?
What is a passive transformation?
What is informatica metadata and where is it stored?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the differences between a connected lookup and unconnected lookup?
How you know when to use a static cache and dynamic cache in lookup transformation?
