Interested to Buy Any Domain ? << Click Here >> for more details...
Kimball and Inmon methodologies?
- 2 Answers
- 17111 Views
- I also Faced
- E-Mail Answers
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 |
where is the reject loader .
what is mean by grouping of condition column in lookup transformation?
create a mapping to retrieve the employees who are getting salary greater than average salary?
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
What is polling?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
can we load the data with out a primary key of a table? what is target plan?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
What are the options in the target session of update strategy transsformatioin?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Teradata 
