DataStage - What is the flow of loading data into fact & dimensional tables?

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 5 of 377

What is the flow of loading data into fact & dimensional tables?

Fact table - Table with Collection of Foreign Keys corresponding to the Primary Keys in Dimensional table. Consists of fields with numeric values.
Dimension table - Table with Unique Primary Key.

Load - Data should be first loaded into dimensional table. Based on the primary key values in dimensional table, the data should be loaded into Fact table.

Total Answers and Comments: 3

Last Update: August 03, 2007

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

January 13, 2006 02:53:29

srinivas vuligonda

RE: What is the flow of loading data into fact & d...

Here is the sequence of loading a datawarehouse.

1. The source data is first loading into the staging area, where data cleansing takes place.

2. The data from staging area is then loaded into dimensions/lookups.

3.Finally the Fact tables are loaded from the corresponding source tables from the staging area.

Is this answer useful? Yes | No

May 24, 2007 08:07:57

sriram

RE: What is the flow of loading data into fact & d...

When does ODS come in to picture ?
I guess its like this
                                    _____Datawarehouse_______
                                   l                                                  l
Source-->Stg-->ODS--l                                                  l-------->Datamart
                                   l_____Fact________________ l

Is this answer useful? Yes | No

August 03, 2007 08:57:35

Siraj

RE: What is the flow of loading data into fact & d...

__________________                      _______________     ________________
|_________________|                     |______________ |     |_______________|
|                                  |                     |                            |      |                              |
|______Flat Files____|                     |                            |      |                              |
|                                  | Stores data |                            |      |                              |
|___SQL Server Files_ | Periodically |                             |      |                              |
|                                  |------------>|       Staging         |--->|    Target Table      |
|_____Java files_____|         |          |         Area            |     |                               |
|                                  |         |          |                            |      |                              |
|_____Sap Files_____|         |          |                            |      |                              |
|                                  |         |          |                            |      |                              |
|___Oracle files_____ |         |          |                            |      |_______________|
|_________________|         |          |______________|      |_Data Warehouse_|
                                              |
Different types of Relational |
Sources                                 |           ________________
                                             |          |________________|
                                             |          |                                |
                                             |          |                                |
                                             |          |          ODS               |
                                             |----->| (Operational Data |
                                Stores Recent  |      Store)                |
                                       Data          |________________|

The data is extracted from the different source systems.After extraction the data is transfered to the staging layer for cleansing purpose.Cleansing means LTRIM/RTRIM etc.The data is coming periodically to the staging layer.An ODS is used to store the Resent data.An ODS and the Staging Area are the two types of layer between the source system and the target system.After that the data is transformed according to the buisness needs with the help of the ETL Transformations.And then the data is finally loaded into the target system or data warehouse.

Is this answer useful? Yes | No

Go To Top