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 -----
This is very nice information for freshers and learners
ReplyDeletehttp://www.tekclasses.com/courses/etl/informatica-training-in-bangalore/