Tuesday, September 8, 2015

Informatica 9.6.1 : Import objects into Informatica repository

Stepwise illustration on how to import objects using Informatica powercenter repository manager.

Step 1 :

Log into repository manager and select "Import objects".

















Step 2 :

Click browse to select XML file which contain the object to import.






















Step 3 :

Select objects to import, Click add.
















Step 4 :

Match folders and select unique folders to import.

















Step 5 :

General import options - Optional options to check in and apply label.




Step 6 :

Conflict resolution wizard. Select appropriate resolution method, Replace, rename or reuse.




Step 7 :

Select appropriate global copy options. For example, retain sequence generator, normalizer or XML current values.




Step 8 :

Click import, once conflicts are resolved.




Step 9 :

Import in progress.




Step 10 :

Sample import summary.

s_m_DW_VEHICLE_DIM_CUST was successfully checked out.
09/08/2015 20:05:13 **** Importing Sequence: SEQ_DW_VEHICLE_DIM ...
SEQ_DW_VEHICLE_DIM was successfully checked out.
    Replacing sequence: SEQ_DW_VEHICLE_DIM
    Validating Target Definition  ETL_DW_VEHICLE_KEY...
09/08/2015 20:06:17 **** Importing Target Definition: SC_ETL_DW_VEHICLE_KEY ...
Object referenced by the shortcut does not exist in the original folder,
object will be imported under the current folder

Validating mapping variable(s).
09/08/2015 20:06:22 **** Importing Mapping: m_DW_VEHICLE_DIM_ROST ...
Validating transformations of mapping m_DW_VEHICLE_DIM_ROST...

Replacing session: s_m_DW_VEHICLE_DIM_CUST
09/08/2015 20:06:40 **** Importing Session: s_m_CACHE_DW_VEHICLE_DIM_PREV ...
------------------------------------------------------------------------------
09/08/2015 20:06:42 ** Saving... Repository REP_INFA_QA, Folder ANALYTICS
------------------------------------------------------------------------------
Target SC_ETL_DW_VEHICLE_KEY inserted.
Transformation Lookup Procedure:SC_LKP_DW_VEHICLE_DIM_PREV inserted.
Transformation Lookup Procedure:SC_LKP_DW_VEHICLE_DIM_CURR inserted.

******** Mapping m_DW_VEHICLE_DIM_CUST is VALID ********
mapping  m_DW_VEHICLE_DIM_CUST updated.
Saving field and table level dependencies...
Target field level dependencies updated.
Target table level dependencies updated.
Validating transformations of mapping m_CACHE_DW_VEHICLE_DIM_PREV...
...transformation validation completed with no errors.
Validating data flow of mapping m_CACHE_DW_VEHICLE_DIM_PREV...
...data flow validation completed with no errors.
Parsing mapping m_CACHE_DW_VEHICLE_DIM_PREV...
...parsing completed with no errors.
------------------------------------------------------------------------------


----- Completed importing selected Objects -----


1 comment:

  1. This is very nice information for freshers and learners
    http://www.tekclasses.com/courses/etl/informatica-training-in-bangalore/

    ReplyDelete