satyaneerumalla

 Profile Answers by satyaneerumalla Questions by satyaneerumalla

• Aug 21st, 2006

 

1)The basic step of datawarehousing starts with datamodelling. i.e creation dimensions and facts.

2)datawarehouse starts with collection of data from source systems such as OLTP,CRM,ERPs etc

3)Cleansing and transformation process is done with ETL(Extraction Transformation Loading) tool.

4)by the end of ETL process target databases(dimensions,facts) are ready with data which accomplishes the business rules.

5)Now finally with the use of Reporting tools(OLAP) we can get the information which is used for decision support.

vinay

• Aug 23rd, 2006

 

very nice answer

    thanks

parimikiran227

 Profile Answers by parimikiran227 

• Aug 31st, 2006

 

nice answer i have more doubts and can u give me ur mail id

jayapraveen

 Profile Answers by jayapraveen 

• Oct 18th, 2010

 

architecture is like

1. Source Systems: Like Mainframe,Oracle,People soft,DB2.

2. Landing tables: These are tables act like source. Used

for easy to access, for backup purpose, as reusable for

other mappings.

3. Staging tables: From landing tables we extract the data

into staging tables after all validations done on the data.

4. Dimension/Facts: These are the tables those are used for

analysis and make decisions by analyzing the data.

5. Aggregation tables: These tables have summarized data

useful for managers who wants to view monthly wise sales,

year wise sales etc. 

6. Reporting layer: 4 and 5 phases are useful for reporting

developers to generate reports. I hope this answer helps you.