Source System Analysis

View previous topic View next topic Go down

Source System Analysis

Post  dwcurious on 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

View user profile

Back to top Go down

Re: Source System Analysis

Post  BoxesAndLines on 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?
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Source System Analysis

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Source System Analysis

Post  BoxesAndLines on 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

avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Source System Analysis

Post  Sponsored content


Sponsored content


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