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