Kimball and Inmon methodologies?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 10 Yes | 2 No |
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
Is This Answer Correct ? | 4 Yes | 4 No |
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
what are objects in data warehouse?
Target increases every day even though no new record was inserted
What is staging area?
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
What is depict expression change?
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
How to identify this row for insert and this row for update in dynamic lookup cache
Which is the best place to learn Informatica Powercenter Online Training?
what is the exact meaning of domain?
What is meant by LDAP users?