Answer Posted / ram reddy

Update Override it is an option available in TARGET
instance.By defalut Target table is updated based on
Primary key values.To update the Target table on non
primary key values u can generate the default Querey and
override the Querey according to the requiremnet.Suppose
for example u want to update the record in target table
When a column value='AAA' then u can include this condition
in where clause of default Querey.

Coming to SQL override it is an option available in Source
Qualifier and Lookup transafornmation where u can inlude
joins ,filters,Group by and order by.

Explain lookup transformation in informatica

1001

---

Which development components of informatica have the highest usage?

980

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2179

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

1983

---

Explain lookup transformation source types in informatica

1037

---

How can we improve session performance in aggregator transformation?

1038

---

What are the types of lookup transformation?

1020

---

How to improve the performance of a session using sorter transformation?

1087

---

Why update strategy and union transformations are active?

986

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1262

---

What is target designer and target load order?

1048

---

list out all the transformations which use cache?

1111

---

Could you explain what is enterprise data warehouse?

1039

---

Describe an informatica powercenter?

1027

---

What is meant by pre and post session shell command?

1103

---