Interested to Buy Any Domain ? << Click Here >> for more details...
What is up date strategy and what are the options for update
strategy?
- 2 Answers
- 10398 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 |
can you use flat file for lookup table?why?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Enlist the tasks for which source qualifier transformation is used.
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
What does role playing dimension mean?
what are the row and column separations in Flat Files
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
Two different admin users created for repository are ______ and_______
What is a mapplet/worklet in informatica?
What is an unconnected transformation?
Teradata 
