Information Analyze is a data profiling tool in Data stage 8.1.
Data Profiling:
1.Data profiling is the process of examining the data available in an existing data source
2.A data source usually a data base or a file
3. By doing data profiling we can collect the statistics and information about data. this is called information analyzer
Data Profiling Tools:
1) Informatica Data Explorer 8x
2) Informatica PowerCenter 8x (Profiling option in Source Analyzer)
3) Oracle Warehouse Builder 10g (Data Profiling node in the Project
Explorer)
4) SQL Server Integration Service (Data Profiling Task)
5) IBM InfoSphere (Information Analyzer)
Why we need Data statistics
- Find out whether existing data can easily be used for other purposes
- whether the data conforms to particular standards or patterns
- Assess whether metadata accurately describes the actual values in the source database
- Understanding data challenges early in any data intensive project, so that late project surprises are avoided. Finding data problems late in the project can lead to delays and cost overruns
Data governance:
Is a quality control discipline for assessing, managing, using, improving, monitoring, maintaining, and protecting organizational information?
In Data stage 8.1 data profiling another name is Information analyzer.
Overview about Data Profiling:
1. Data profiling helps you create data model of the 3’rd normal form, based solely on data available in the source system
2. In order to create a data model of the 3’rd normal form we need the following information
1) Domain - Column Data type and Length.
2) Dependency – Primary Key.
3) Relationship - Foreign Key .
0 comments:
Post a Comment