What is up date strategy and what are the options for update
strategy?
- 2 Answers
- 9461 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jyothi
Update strategy is used for flagging the records by using
the options insert/update/delete/reject.
Update strategy is used in two levels.
session level:at session level we have to use the options
update as insert,update as update,update else insert.
mapping level:at mapping level we have to use the options
dd-insert,dd-update,dd-reject,dd-delete.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / mkolari
We can use update strategy at two different levels
1) within a session :- When you are configuring a
session you can give instructions to treat a)all rows as
insert b)all rows as update c)data driven (use instructions
coded into the session mapping to flag rows for different
database operations.)
2) within mapping :- You can flag rows for
insert,update,delete or reject.
Don't forget to set "Treat source rows as" to Data Driven
in the session properties if you are flagging rows within
the mapping.
| Is This Answer Correct ? | 2 Yes | 2 No |
What are the differences between a connected lookup and unconnected lookup?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
How big was your fact table
How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica
What are the mapings that we use for slowly changing dimension table?
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
How to convert flat file into xml file? How to tune joiner?
What are the uses of etl tools?
What is the target load order?
what is lookup ?
explain about lookup t/r?
Teradata 
