Major difference between SQL override and Lookup Sql override

1 Answers  

---

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  

---

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

---

What are the options in the target session of update strategy transsformatioin?

2 Answers  

---

In session log thier should not be a single error how will u do

3 Answers   HCL,

---

why union transformation is active transformation?

6 Answers   IndiGo, TCS,

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 Answers  

---

there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  

---