• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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

Summary
Review Date
Reviewed Item
Overloading and its types in Informatica
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Overloading and its types in Informatica"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.