Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Data extraction from a datawarehouse

Go down

Data extraction from a datawarehouse Empty Data extraction from a datawarehouse

Post  yvivek02 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

Back to top Go down

Back to top

- Similar topics

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