What is the functionality of update strategy?
Answers were Sorted based on User's Feedback
Answer / sivaprasad
Update strategy defines the sources to be flagged for
insert, update,
delete, and reject at the targets.
What are update strategy constants?
DD_INSERT,0 DD_UPDATE,1 DD_DELETE,2
DD_REJECT,3
If DD_UPDATE is defined in update strategy and Treat source
rows as INSERT in Session . What happens?
Hints: If in Session anything other than DATA DRIVEN is
mentions then Update strategy in the mapping is ignored
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / chluff12
to decide to insert, update, delete or reject the data.
| Is This Answer Correct ? | 0 Yes | 0 No |
how do the project develops? pls specify right from the start to end in step by steps.
What is Collect performance data in informatica and what is the use of it.
How to Join Tables my Source is having 15 table target is one?
What is a candidate key?
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
Explain the types of lookup transformation?
in what type of scenario bulk loading and normal loading we use?
Whats the difference between $, $$, $$$
how to join the 2 different table with different columns in informatica?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort