Oracle data warehousing using SAP BODS

[Former Member]

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

[former_member208402]

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