Answer Posted / souvik

We need to have a Lookup with a Dynamic Cache, a Router, an Expression and then an Update Strategy..... The Lookup will be on the Target Table..... So when the ID is coming for the first time, it wont found any data on the lookup table.... This can be directed for Insertion to the Target Table via a Router.... Then when the same ID is coming for the second time, it will Lookup on the Target Table and will found that the row with the ID exists.... Hence both the columns from the source table and both the columns from the Lookup are taken forward into the Router and then to an Expression Transformation where the second port is Concatenated. Then the ID port and this port is taken to the Update Strategy transformation for Update...

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2060

---

Differences between connected and unconnected lookup?

1218

---

What does reusable transformation mean?

1132

---

What are the different options available for update strategy?

1003

---

How to load a Dimension ? and how to load a fact table?

1418

---

What will be the approach?

979

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1767

---

have u done any performance tuning? how u ll do?

2299

---

Clarify the utilization of aggregator cache record?

1002

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1904

---

What is dynamic cache?

1036

---

lookup transformation with screenshots

4006

---

What do you mean incremental aggregation?

1076

---

What are the different components of powercenter?

1055

---

Differentiate between sessions and batches?

1018

---