Data extraction from a datawarehouse
Page 1 of 1
Data extraction from a datawarehouse
Hi,
I am in design in charge for a large datawarehouse which provides data to other analytic systems like Campaign Management, Dealer and Sales Management for their use. This requires data to be pulled from warehouse and apply certain rules which are specific to the end system requirements. For e.g. there can be different definitions of first time user, repurchase and so on depending upon the use of the data.
I am faced with certain design options where:
- To extract and provide raw data to downstream applications and let them process it as per the definition. DOwnstream applications do not favour this as they complain of not having enough processing power and dont understand the BI data well
- To provide processed data as per their definition. This increases the operation over head and is not favored by operations
Would like some industry best practices, guidelines to arrive at a decision in such cases.
I am in design in charge for a large datawarehouse which provides data to other analytic systems like Campaign Management, Dealer and Sales Management for their use. This requires data to be pulled from warehouse and apply certain rules which are specific to the end system requirements. For e.g. there can be different definitions of first time user, repurchase and so on depending upon the use of the data.
I am faced with certain design options where:
- To extract and provide raw data to downstream applications and let them process it as per the definition. DOwnstream applications do not favour this as they complain of not having enough processing power and dont understand the BI data well
- To provide processed data as per their definition. This increases the operation over head and is not favored by operations
Would like some industry best practices, guidelines to arrive at a decision in such cases.
yvivek02- Posts : 1
Join date : 2013-02-27
Similar topics
» datawarehouse appliances
» DataWarehouse Data Model - financial Serivces
» Extraction layer on SOA/ESB architecture
» What is the criteria to decide on Extraction vs Report (ing)
» Incremental Extraction Methods From Highly Normalized Source
» DataWarehouse Data Model - financial Serivces
» Extraction layer on SOA/ESB architecture
» What is the criteria to decide on Extraction vs Report (ing)
» Incremental Extraction Methods From Highly Normalized Source
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum