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.

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.

what is session override?

2 Answers   Cap Gemini,

---

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

---

What are the advantages of using informatica as an etl tool over teradata?

0 Answers  

---

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

---

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?/

5 Answers   L&T,

---

what is materialized view?

2 Answers  

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

---

please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,

---

How to eliminate 1st and last rows from the source and load the inbetween rows.

5 Answers   Syntel,

---

Can we use unconnected lookup as dynamic lookup?

5 Answers   ITC Infotech, TCS, Wipro,

---

What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,

---

When the informatica server marks that a batch is failed?

1 Answers  

---