Answer Posted / kajal mishra

Yes we can update records in informatica without update strategy .

During session configuration, you can select a single database operation for all rows using the Treat Source Rows as setting from the ‘Properties’ tab of the session.

Insert :- Treat all rows as inserts.
Delete :- Treat all rows as deletes.
Update :- Treat all rows as updates.
Data Driven :- Integration Service follows instructions coded into Update Strategy flag rows for insert, delete, update, or reject..

In case we set treat rows as update , we can set more option for individual target tables.
I found a good asrticle on http://tutorialcorner.com/2016/03/update-without-update-strategy-in-informatica/

What is transformation?

1099

---

tell me 5 session failure in real time how can you solve that in your project?

2305

---

What could be the possible resons of locks by user?

1094

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1641

---

What is a joiner transformation?

997

---

What is data transformation manager process?

1158

---

Differentiate between reusable transformation and mapplet.

1096

---

Explain the different dimensions.

967

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1257

---

What is the benefit of session partitioning?

1116

---

What are mapplets? How is it different from a Reusable Transformation?

1092

---

Differentiate between Load Manager and DTM?

2154

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2131

---

What is aggregate cache in aggregator transformation?

1145

---

What is the command used to run a batch?

1064

---