mobileNavlogo
headerlogo

Overloading and its types in Informatica

07 October, 2020

Ratings

Related Blogs

 

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

About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .