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

What is the criteria to decide on Extraction vs Report (ing)

Go down

What is the criteria to decide on Extraction vs Report (ing) Empty What is the criteria to decide on Extraction vs Report (ing)

Post  rrbhupathi Tue Aug 28, 2012 2:50 pm

Hi,

Most of our reports generates more than 100K of records at the participant level;

Our thought is in those scenario's users should use Data Extraction tools like Informatica instead of extracting the data through reporting tools like Cognos;

I am trying to get clear on what should be the criteria to decide on whether to use Data Extraction tool vs reporting tool;

Appreciate if somebody can throw some insights on this topic


Thanks

rrbhupathi

Posts : 1
Join date : 2012-08-28

Back to top Go down

What is the criteria to decide on Extraction vs Report (ing) Empty Re: What is the criteria to decide on Extraction vs Report (ing)

Post  ngalemmo Tue Aug 28, 2012 8:26 pm

In what context? Are these reports against a data warehouse or an operational system?

If it is against a data warehouse, what advantage do you believe you would gain if you did an extraction? A report is an extraction. What's the difference?

If you are talking about an operational system, then you may consider creating a data warehouse. The decision to actually build a data warehouse would usually occur after there have been serious problems with users running very large reports while the rest of the company is trying to conduct business.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Back to top


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