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:
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:
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
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
About Author
Name
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 in the market.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox