Answer / abhinav

Update Override is an option in Informatica at the session
level. In this, you can manually enter the SQL query to be
used. This query will be issued to the Database when the
session is run, overriding the SQL query generated by that
particular transformation at the mapping level.

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  

---

what is target load plan

2 Answers   Cap Gemini,

---

in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?

2 Answers   Thomson Reuters,

---

Which are the different editions of informatica powercenter that are available?

0 Answers  

---

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

---

What is critical mapping?

2 Answers  

---

explain one complex mapping with logic? sales project?

0 Answers   Accenture, JPMorgan Chase,

---

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

---

what are types of dimentions?

3 Answers  

---

How you can differentiate between connected lookup and unconnected lookup?

0 Answers  

---

What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  

---

Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

10 Answers   CSC,

---