Data extraction from a datawarehouse

View previous topic View next topic Go down

Data extraction from a datawarehouse

Post  yvivek02 on Wed Feb 27, 2013 1:58 am

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.

yvivek02

Posts : 1
Join date : 2013-02-27

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum