Overloading and its types in Informatica

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

Interested in mastering Informatica Training? 

Enroll now for FREE demo on Informatica Training Online.

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