Every company has methodology of their own. But to name a few SDLC Methodology AIM methodology are stardadly used. Other methodologies are AMM World class methodology and many more.

Most probabally Every one fallows

Either starschema or snowflake schema

hello sir

i am raja i am doing my final year B.Tech (I.T) i am doing my final sem project in data warehouse title is INVENTORY SYSTEM . in our college documentation we use one procedure so i need the methodologies now i am using the water fall model in SDLC. is it correct or not. only use the schema is the methodologies for dwh.

please help me sir.

Regarding the methodologies in the Datawarehousing . They are mainly 2 methods.

1. Ralph Kimbell Model

2. Inmon Model.

Kimbell model always structed as Denormalised structure.

Inmon model structed as Normalised structure.

Depends on the requirements of the company anyone can follow the company's DWH will choose the one of the above models.

In Data warehousing contains the Two Methods

1>> Top Down Method

2>>Bottom up method

In Top Down method First load the Datamarts and then load the dataware house.

In Bottom Up method first load the Data warehouse and then load the Datamarts.

Top Down approach is first Data warehouse then Datamarts.

Bottom Down approach is first Datamarts then Data warehouse.

Yes

There are 2 methodalogies 1. Kimball 2. Inmon likewise 1. Star Flake 2. Snow Flake schemas

There are two appoaches in Dataware housing named as

Top Down Approach and Bottom-up Approach

Top down approach in the sense preparing individual departments data(DataMarts) from the Enterprise DatawareHouse

Bottom Up Approach is nothing but first gathering all the departments data and then cleanse the data and Transofrms the data and then load all the indivisual departments data into the enterprise data ware house