Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

---

whats the logic to load the lower level of granularity of data to fact table.

0 Answers   IBM,

---

What is joiner transformation in informatica?

0 Answers  

---

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

---

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

---

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

---

What are the basic needs to join two sources in a source qualifier?

4 Answers  

---

Enlist the differences between database and data warehouse.

0 Answers  

---

What is the Difference between sorter and aggregator?

2 Answers  

---

On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 Answers  

---

What is a joiner transformation and why it is an active one?

0 Answers  

---

Explain pushdown optimization and types in informatica

0 Answers   Informatica,

---