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 |
How to delete duplicate record in Informatica?
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
can we use self join in informaitca?
How do you change parameter when you move it from development to production.
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is galaxy shema
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is surrogate key?
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
What is a test load?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
what are 3 tech challenges/ common issues you face?