Impacted Mappings Sessions and Workflows

Impacted Mappings

       Mapping may contains sources, targets transformations and mapplets. Sometimes the transformations are reusable.
   
      Generally mappings will be impacted if any of the components in the mapping changed such as sources or targets.  Sources or Targets are the child's of the mapping. The same source and target can be used in multiple mappings.

     There are two mappings A and B using same target. There is a change came in mapping A. For this reason you changed target structure i.e re imported. You have done changes in the mapping A after you imported. But you have not touched the mapping B. In this case mapping B will be impacted. The impacted mapping you can see with yellow color triangle symbol. What you need to do is check out the mapping B and validate the mapping and then save. Then that symbol will disappeared. For any more information on the impacted mappings please feel free to contact informaticaexpertise@gmail.com

Impacted Sessions

        When ever there is a change in the mapping, first apply the changes and we validate it. Important thing is need to refresh the session also. If you forget to refresh the session and when you try to fetch the session automatically the session will be impacted. First you need to check out the session and validate or double click on the session to get the latest changes into the session level and then save it.

            If you want to learn in depth or master about DWH and informatica power center tool please see the below video.

https://www.youtube.com/watch?v=5MxpqN7B6m8

Impacted Workflows

               When you do the changes for session under task developer tool for existing session in the workflow, if you don't validate the workflow after session check in, the workflow will be in impacted state. You need to check out the workflow validate and then check in again.

About Informatica Power Center

Informatica is a company or corporation. The company provided different kinds of tools to perform ETL operations. Power Center is one of the powerful tool to perform ETL operations.

The informatica power center software divided into two parts.
1. Client
2. Server

In order to install server you need one database (Any Relational Database Eg:- Oracle). You can install client directly.

When you install power center client, you will get following tools automatically.

1. Power Center Designer

2. Power Center Workflow Manager

3. Power Center Workflow Monitor

4. Power Center Repository Manager


As informatica developer you are going to closely work with first three tools

• Power Center Designer
• Power Center Workflow Manger
• Power Center Workflow Monitor

Informatica Adminstrator is mainly used Power Center Repository Manager and Administration Console to perform all kinds of administration activities.

Power Center Designer

The Power Center Designer tool is used to

a) import source structures

b) import target structures

c) create reusable transformations

d) create reusable mapplets

e) create mappings

The Power Center Tool itself contain following tools

 i) Source Analyzer: To create or import source structures

 ii) Target Designer: To create or import target structures

iii) Transformation Developer: To create reusable transformations

iv)  Mapplet Designer: To create mapplets

v)  Mapping Designer: To create mappings

 A mapping is nothing but logical representation of data flow, how to move data from source to target

Power Center Workflow Manager

The Power Center Workflow Manager tool is used to

a) Create sessions

b) Create different types of tasks such as command, email, decision, timer etc

c) Create worklets

d) Create workflows

The Power Center Workflow Manger itself contains following tools

i) Task Developer: To create session/command/email tasks

ii) Worklet Designer: To create worklets

iii) Workflow Manger: To create workflows and scheduling of workflows

The Power Center tool comes under ETL tools. Generally ETL tool is used in DWH projects. As a ETL Devloper you need to understand DWH concepts also, interivew point of view also very important. Watch the below video and get more information.

https://www.youtube.com/watch?v=Zh6W0gxXwsY&feature=youtu.be

When you try the job on informatica developer in the market, genertally they will ask questions on inforamtica and one database and unix.

Power Center Workflow Monitor

The Power Center Workflow Monitor tool is used to view the load statistics, how many rows read from source and how many rows loaded into target and how many rows entered into reject etc

There are two views under this Power Center Workflow Monitor

1. Ganttchart View

2. Task View

When you run a workflow automatically workflow monitor tool will open