Answer / anju

Kimball: Data warehouse is combined of all the data marts
in an enterprise.Inofrmation is stored in dimensional model
Inmon:Datawarehouse is a part of business Intelligence
system. An enterprise has one data warehouse and data marts
source information from the datawarehouse.Information is
stored in 3rd normal form

Practically most of the enterprise data warehouses
following Ralph Kimball's methodology.Started as Data marts
and then evolve into data warehouse.

Answer / raghu

KIMBALL FIRSTDEVOLEP DATAMATRS
INMON FIRST DEVOLP DATAWAREHOUSE
KIMBOLL:DWH IS ANALYTICAL PROCESSING OF DATA
IMMON:DWH IS SUBORITENED,INTEGRETED,NONVOLATILE
(PERMENT),TIMVARIANT DATEBASE

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  

---

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

---

how we can update a target table without update strategy and update override?

3 Answers   TCS,

---

What is limitations of truncate and load option

1 Answers   Cap Gemini,

---

How do you load unique records into one target table and duplicate records into a different target table?

0 Answers  

---

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

---

what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers   Virtusa,

---

How the dimensions will be loaded?

0 Answers   HCL,

---

Explain the informatica workflow?

0 Answers  

---

what is the predefined port in dynamic lookup

2 Answers  

---

What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,

---

what is materialized view?

2 Answers  

---