data services designer provides a feature of data profiling to ensure and improve the quality and structure of source data.

data profiler allows you to −

• find anomalies in source data, validation and corrective action and quality of source data.

• define the structure and relationship of source data for better execution of jobs, work flows and data flows.

• find the content of source and target system to determine that your job returns an expected result.

data profiler provides the following information of profiler server execution −

column analysis

• basic profiling − includes information like min, max, avg, etc.

• detailed profiling − includes information like distinct count, distinct percent, median, etc.

relationship analysis

• data anomalies between two columns for which you define a relationship.

data profiling feature can be used on data from the following data sources −

• sql server
• oracle
• db2
• attunity connector
• sybase iq
• teradata

connecting to profiler server

to connect to a profile server −

step 1 − go to tools → profiler server login

step 2 − enter the details such as system, user name, password and authentication.

step 3 − click the log on button.

when you are connected, a list of profiler repositories will be displayed. select repository and click connect.