Creating a Column Profile on a Logical Data Object in Informatica Developer

Back Next

Business Example

You are a data analyst in an International Bank. The bank acquires a National Bank. After the acquisition, the International Bank wants to find all the customers residing within a ZIP code location while identifying data quality issues associated with the selected records.

To accomplish the task, you must perform the following steps:

Create a logical data object model and name it Customer_LDOM.

Create a logical data object and name it Customer_LDO.

Create flat file data objects for the Customer tables in the International Bank database and National Bank database.

Create a mapping with a Joiner transformation, and map the flat file data objects to the logical data object.

Create a column profile on the logical data object, and view the profile results.

You can view the profile results in Informatica Developer and Informatica Analyst. In Informatica Analyst, you can view the null values, inferred data types, inferred patterns, values, and frequencies for all the columns in summary view.

The following tasks explain how to create a logical data object and create and run a column profile on the logical data object.

Rename Saved Search

Table of Contents

Creating a Column Profile on a Logical Data Object in Informatica Developer

Creating a Column Profile on a Logical Data Object in Informatica Developer

Business Example

Business Example