Answer Posted / nav

u can use autosys scheduler,or workflow manager in
informatica

What is a dimensional model?

977

---

How do you update the records with or without using update strategy?

1111

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1007

---

What is the format of informatica objects in a repository?

1016

---

What is standalone command task?

1311

---

What is DR strategy for Informatica project?

1172

---

How we can use union transformation?

1045

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1788

---

Explain the different kinds of facts.

978

---

What is data caches/ index caches?

1097

---

What is different between the data warehouse and data mart?

1058

---

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

1902

---

What is the surrogate key?

1252

---

difference between informatica 8.1.1 and 8.6

3675

---

Explain what transformation and how many are there in informatica?

944

---