Answer / mike

session override is an option in informatica at session
level. Here we can maually give an sql query which is
issued to the database when the session runs. It is nothing
but over riding the default sql which is generated by a
particular transformation at mapping level.

correct me if i was wrong

Answer / guduri

i think mike is correect

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

---

Define Incremental Aggregation?

2 Answers  

---

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

---

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

---

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

---

When the informatica server marks that a batch is failed?

2 Answers  

---

how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

3 Answers   Cognizant, HP, TCS,

---

What is the default join that source qualifier provides?

3 Answers   Informatica,

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

0 Answers   HP,

---

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  

---

what is constraint based load order

2 Answers   Cap Gemini,

---

How do we call shell scripts from informatica?

0 Answers  

---