Fact table data loading.

993000

HI All ,

I am here posting one question about the data ware house concept I would like to know that .

I am working on the OBIA 11.1.1.10.1 in this I have seen that while data is loading from source to ware house i.e in extraction of data from source and then loading the data in the ware house though the ODI .The data is loading in to the fact table and then it is loading in to the Dimension table.

As I know that the fact table consists of Foreign Key and Dimension table consists of Primary Key .But why the data is loading in to the fact table first and then it is loading in to the Dimension table while SDE jobs are executing .

Could you please let me know what is the general process and is there any standard process is there for the data loading from the source to ware house as the fact table is first and then Dimension table is next or any dependency is there .

Could you please help me on this if any once aware about.

Thanks

John_K

It doesn't matter in the SDE phase - because that's just loading the staging tables. In the SIL phase, dimensions must be loaded before facts as the lookups are done in the fact load to get the WID's.

GBajaj

In SDE layer, Fact Stage and Dimention stage tables are populated with out the references of each other.

In other words, while loading a Fact stage table actual value of Dimension gets stored.

In SIL layer, dimension would be inserted first and then fact would insert so that actual dimensional value in fact gets stored as WID reference key.

Charles M

Good discussion, all.

Here is a pretty good blog that talks about some of this:

uksanjay.blogspot.com/2014/11/wid-warehouseid-in-obiee.html

Regards,

Charles