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 will you combine 3 different sources with a single source?

3 Answers  

---

how do u move the code from development to production?

3 Answers  

---

Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve

15 Answers   TCS,

---

How do you create single lookup transformation using multiple tables?

6 Answers   TCS,

---

In warehouses how many schemas are there?

0 Answers  

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,

---

r u done any partitions in ur project?

0 Answers   TCS,

---

Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,

---

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

0 Answers   IBM,

---

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,

---

any body can say about all versions of informatica ?how many versions ?

2 Answers  

---