What is up date strategy and what are the options for update
strategy?
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 is mapping parameter and mapping variables
What are the different ways to implement parallel processing in informatica?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
How can one identify whether mapping is correct or not without connecting session?
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
How to eliminate duplicates in FF and oracle both
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
what is the difference between lookupoveride and joiner?
In a table, 4 person having same salary. How to get Third person record only?