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 session override?
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
What are the advantages of using informatica as an etl tool over teradata?
how to import multiple flat files in to single target where there is no common column in the flat files
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
what is materialized view?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
How to eliminate 1st and last rows from the source and load the inbetween rows.
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
What are the challenges you have faced in your project?
When the informatica server marks that a batch is failed?