Answer Posted / saradhi

i think its happen only if the target table does not have
any primary key.

Explain the use of aggregator cache file?

1205

---

COM components can be used in Informatica

2340

---

how to load dimension table and fact table. plz tell me the steps.

2055

---

What are the different options available for update strategy?

961

---

What is main use of mapplet?

1088

---

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

2018

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2203

---

What are the types of caches in lookup? Explain them.

935

---

How to generate sequence numbers without using the sequence generator transformation?

1153

---

can you please explain me pre session and post session options?

7459

---

What is the meaning of decode in informatica?

1089

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1110

---

Explain the tuning lookup transformation - informatica

967

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1862

---

waht type of interface is used for testing the data in informatica

2207

---