Skip to Content
avatar image
Former Member

Oracle data warehousing using SAP BODS

Hi,

I am very new to data warehousing(Oracle) projects. I have only data migration experience in BODS. Now i got an opportunity to work in Oracle Data warehousing where BODS is an ETL. I have some doubt which i have mentioned below.

1.Could any one provide the document or link to understand the BODS process in warehousing?.

2. I believe that there are some terminologies like DATA QUBE and DATA MART. Whether BODS will do the loading for those two?.

3. There are two schema in DWH 1. Star 2.Snowflake. Whether BODS will do the loading by using this schema?.

Please clarify me on this.

Regards,

DHILEEP

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 17, 2017 at 08:59 AM

    1.Could any one provide the document or link to understand the BODS process in warehousing?.

    ANS :- First understand the DWH concepts, try google and go through all the DWH concepts

    2. I believe that there are some terminologies like DATA QUBE and DATA MART. Whether BODS will do the loading for those two?.

    ANS:- you will load Tables using BODS be it a DATA MART or CUBE. so learn DWH concepts

    3. There are two schema in DWH 1. Star 2.Snowflake. Whether BODS will do the loading by using this schema?.

    ANS :- Data modelers will create/develop schemas and BODS will load tables in the schemas. learn DWH concepts for better understanding of all these questions.

    Thanks,

    Ravi kiran

    Add comment
    10|10000 characters needed characters exceeded