reddy

• Mar 13th, 2007

 

Data Profile,Data Cleanching is used to verify the data types

vikki_gupta2003

 Profile Answers by vikki_gupta2003 

• Mar 14th, 2007

 

Hi Reddy,

Could you tell me what do u mean by DATA PROFILE?

Thanks in advance..

vizaik

 Profile Answers by vizaik 

• Mar 24th, 2007

 

go to source analyzer
import databases
go to warehouse designer
import databases (target definitions) else create using generate sql
go to mapping designer
drag and drop sources and targets definitions
link ports properly
save to repository

than q

ramsetty

 Profile Answers by ramsetty 

• Jun 17th, 2009

 

Data profiling is a technique used to analyze the content, quality, and structure of source data. Use PowerCenter Data Profiling to detect patterns and exceptions of source data during mapping development and during production.

The one major reason for Data Profiling in Data warehouse is to validate business rules about the source data. For instance assume, you have a business rule requiring columns in a source table to contain ZIP Codes, you can profile the source data to verify that the rows in the concerned tables contains proper values.

This is one typical
scenario that you could make use of Data Profiling in Data warehouse.

Cheers
P.R