A Agarwal

• Sep 11th, 2006

 

ODS--Operational Data Source, Normally in 3NF form. Data is stored with least redundancy.

General architecture of DWH

OLTP System--> ODS ---> DWH( Denomalised Star or Snowflake, vary case to case)

calltomadhu

 Profile Answers by calltomadhu 

• Sep 22nd, 2006

 

This consept is really good. I will tell u clearly.

Assume that i have one 24/7 company. Peak hours is 9-9. ok in this one per day around 40000 records are added or modified. Now at 9'o clock i had taken a backup and left. after 9 to 9 again instead of stroing the data in the same server i will keep from 9 p.m to 9 a.m. data i will store saperatly. Assume that 10000 records are added in this time. so that next day moring when i am dumping the data there is no need to take 40000+10000. It is very slow in performance wise. so i can take directly 10000 records. this consepct what we call as ODS. Operational Data Source.

Arch can be in two ways.

ODS to WH

ODS StagingArea wh

Thanks & regards

madhu

Sravan Gopisetty

• Sep 24th, 2006

 

ODS is an Integrated view of Operational sources(OLTP).

crishnathk

 Profile Answers by crishnathk 

• Dec 12th, 2006

 

thq from ur answer i can come to one conclusion tht ODS is used to store the current data.

i can assume tht by defalut it will add tht 40000 records to this current data 10000 records n gives the reslut 50000.

cud u plz reply to this......

thq...