Overloading and its types in Informatica

Constraint base load ordering: (CDl)

        Specific the load order based on PK and FK relation ship the target tables

Business purpose:

Overloading and its types in Informatica

Procedure:

Create the source and target definitions

Defined a mapping with the name M_ CDL

Create a session with the name S_M CBL

Double click the session select the configure object tab

Attribute

Value

Constraint based load ordering 

 

 

Selecting the mapping tab

Set the appropriate order and writer connections click apply

Click ok

Target load plan [TLP]:

A TLP defines the order in which data extracted from source quantifier transformation

If you want to enrich your career and become a professional in Informatica, then visit Tekslate - a global online training platform: "Informatica Training" This course will help you to achieve excellence in this domain.

ETL architecture:

Overloading and its types in Informatica

Create the source and target definition

Create a mapping with the name M_ TLP with the 2 pipe lines as defined above

From mapping menu select targ load plan

Change the target load order using up and down arrows

Click ok, from repository menu click save

For indepth understanding of Informatica, click on