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
- 21118 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 a snowflake schema?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
draw informatica architecture 8.6 ?
What are Dimensional table?
Explain lookup transformation in informatica
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How do you set a varible in incremental aggregation
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the popular informatica products?
What is Cognos script editor?
What is a sequence generator transformation?
How is union transformation utilized?
What are the features of complex mapping?
Explain pmcmd command usage in informatica
