Interested to Buy Any Domain ? << Click Here >> for more details...
What are the options in the target session of update
strategy transsformatioin?
- 2 Answers
- 10738 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
Insert
Delete
Update
Update as update
Update as insert
Update esle insert
Truncate table
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / santhoshi
INSERT
UPDATE AS UPDATE
UPDATE AS INSERT
UPDATE ELSE INSERT
DELETE
TRUNCATE TARGET TABLE
| Is This Answer Correct ? | 2 Yes | 1 No |
Explain pushdown optimization and types in informatica
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.
What is the difference between stop and abort in informatica
source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009
Explain reference cursor?
How do you set a varible in incremental aggregation
Where can we find the throughput option in informatica?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
My source table having some records ,i want load 1st record and last record into one target?
Why is meant by direct and indirect loading options in sessions?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
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?
Teradata 
