Answer / john

Bydefaultly the option in the session properties "Treat
source rows as" is set as Insert.But When we use
Updatestrategy in our mapping, the option in the session
level automatically becomes "Data driven".that means all
the source rows are treated as per the condition you
specified in the updatestrategy transformation.lets say you
have specified as "DD_UPDATE" then integartion service will
treat all the source rows as "UPDATE".
Actually when we use Updatestrategy transformation in
mapping level there is no need of change the settings in
the session level..as i told you earlier the option "Treat
source rows as" is bydefaultly Insert.
But with out using Updatestrategy how wll the Update the
records? or How will you Reject the records? or How will
you Delete the records?
The answer for this Question is...By using the option
called "Treat source rows as"..
so Use this option when you want to update/Reject/Delete
the records with out using the Updatestrategy in mapping
level..

how can u tune u r informatica mapppings

2 Answers   CTS,

---

have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,

---

can you use flat file for repository?why?

2 Answers   TCS,

---

how many types transformations supported by sortedinput?

4 Answers  

---

what is parallel querying and what r hints.

1 Answers  

---

How to delete duplicate record in Informatica?

7 Answers  

---

Enlist few areas or real-time situations where informatica is required.

0 Answers  

---

Could any one to tell Fact table Partitioning?

2 Answers  

---

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

---

what is a junk dimension ?

14 Answers   Atos Origin, Cognizant, HS, NIIT, TCS,

---

Using Expression transformation how to remove duplicate records from a relational source?

4 Answers  

---

Two Default User groups created in the repository are ____ and ______

2 Answers  

---