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

Source System Analysis

3 posters

Go down

Source System Analysis Empty Source System Analysis

Post  dwcurious Tue Nov 15, 2011 12:30 pm

I need to perform Source system analysis for existing DWH. I was wondering what are things that are done in Source system analysis. Kindly help as its crucial

dwcurious

Posts : 20
Join date : 2011-04-14

Back to top Go down

Source System Analysis Empty Re: Source System Analysis

Post  BoxesAndLines Tue Nov 15, 2011 3:35 pm

I don't mean to be flippant, but if you don't know what it is, how do you know it is crucial?
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Source System Analysis Empty Re: Source System Analysis

Post  ngalemmo Tue Nov 15, 2011 4:03 pm

BoxesAndLines wrote:I don't mean to be flippant, but if you don't know what it is, how do you know it is crucial?

Me thinks he means crucial for him to understand because he has been asked to do it.

Source system analysis is analysing the processes and data in the systems that support the business. It should lead to the identification of data sources, their content, and availibility for extract into a DW.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Source System Analysis Empty Re: Source System Analysis

Post  BoxesAndLines Wed Nov 16, 2011 10:05 am

I agree, it is crucial. It is a common question when I interview data analysts. To understand what you are trying to accomplish simply go to a vendor's website that sells a data profiling tool. I copied this from ERwin Data Profiler;

Column Profiling and Analysis: Helps reduce analysis cycles and increases their effectiveness through consistent and standardized results. In addition, this functionality enables the automatic discovery of standard column statistics, including:

•Data type
•Value frequency
•Length
•Precision
•Scale
•Blank count
•Formats
•Cardinality
•Selectivity
•Non-null selectivity
•Non-null count
•Min
•Max
•Mode
•Mode %
•Null count

BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Source System Analysis Empty Re: Source System Analysis

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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