Informatica Analyst Tutorial
During this tutorial, an analyst logs into the Analyst tool, creates a project and folder, creates data objects, and creates a mapping specification.
The following table describes the lessons you will perform in the tutorial:
Lesson | Description |
|---|
Lesson 1. Setting up Informatica Analyst | Log in to the Analyst tool and create a project and folder for the tutorial lessons. |
Lesson 2. Creating Data Objects | Import flat files and a table as data objects and preview the data. |
Lesson 3. Creating a Mapping Specification | Create a mapping specification to develop the business logic that transforms and moves data from source to target and populates a target table. |
The Tutorial Story
HypoStores Corporation is a national retail organization with headquarters in Boston and stores in several states. It integrates operational data from stores nationwide with the data store at headquarters on regular basis. It recently opened a store in Los Angeles.
The headquarters includes a central ICC team of administrators, developers, and architects responsible for providing a common data services layer for all composite and BI applications. The BI applications include a CRM system that contains the master customer data files used for billing and marketing.
HypoStores Corporation wants to integrate the Boston and Los Angeles data sets. HypoStores wants to create mapping specifications to develop business logic that transforms and moves data from sources to a target. Hypostores can then leverage the data in the target to run reports.