...
Here is a more complex example. Mapplets look a bit tricky (see the lookup_procedure):
| Code Block | ||
|---|---|---|
| ||
Informatica(r) PMREP, version [9.1.0 HotFix4], build [449.0224], Windows 64-bit Copyright (c) Informatica Corporation 1994 - 2012 All Rights Reserved. This Software is protected by U.S. Patent Numbers 5,794,246; 6,014,670; 6,016,501; 6,029,178; 6,032,158; 6,035,307; 6,044,374; 6,092,086; 6,208,990; 6,339,775; 6,640,226; 6,789,096; 6,820,077; 6,823,373; 6,850,947; 6,895,471; 7,117,215; 7,162,643; 7,254,590; 7,281,001; 7,421,458; 7,496,588; 7,523,121; 7,584,422; 7,720,842; 7,721,270; and 7,774,791, international Patents and other Patents Pending. Invoked at Thu Apr 24 15:48:17 2014 REP_SVC_DEV EDW_POS_TICKET lookup_procedure non-reusable m_LOAD_TICKET_DETAIL_STG.lkp_SALES_TYPE_ID 1 REP_SVC_DEV EDW_POS_TICKET lookup_procedure non-reusable mplt_PRODUCT_LOOKUP_OR_ALIAS.LKP_PRODUCT_ALIAS_R2_ABS_PLU 1 REP_SVC_DEV EDW_POS_TICKET scheduler non-reusable wkf_LOAD_TICKET_DETAIL_STG.Scheduler 1 REP_SVC_DEV EDW_POS_TICKET lookup_procedure non-reusable m_LOAD_TICKET_DETAIL_STG.lkp_POS_SYSTEM_TYPE 1 REP_SVC_DEV EDW_POS_TICKET start non-reusable wkf_LOAD_TICKET_DETAIL_STG.Start 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_TICKET_DETAIL_STG.EXP_COLLECT_CONDIMENT_SEQ_NUM 1 REP_SVC_DEV EDW_POS_TICKET mapping m_LOAD_TICKET_DETAIL_STG 1 REP_SVC_DEV SHARED_POS_ODS sequence reusable seq_TICKET_DETAIL_ID_SK 1 REP_SVC_DEV EDW_POS_TICKET source_qualifier non-reusable m_LOAD_TICKET_DETAIL_STG.SQ_sc_TICKET_DETAIL_AUD 1 REP_SVC_DEV EDW_POS_TICKET output_transformation non-reusable mplt_PRODUCT_LOOKUP_OR_ALIAS.OUTPUT 1 REP_SVC_DEV EDW_POS_TICKET lookup_procedure non-reusable m_LOAD_TICKET_DETAIL_STG.lkp_PRODUCT_SIZE 1 REP_SVC_DEV SHARED_POS_ODS target TICKET_STG 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_TICKET_DETAIL_STG.EXP_DEFEAT_PRODUCT_SIZE_LOOKUP_NT 1 REP_SVC_DEV EDW_POS_TICKET sequence reusable sc_seq_TICKET_DETAIL_ID_SK 1 shortcut REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_TICKET_DETAIL_STG.exp_BR_IND_VALID_PLU 1 REP_SVC_DEV SHARED_EDW expression reusable exp_DATE_CONVERSION 1 REP_SVC_DEV EDW_POS_TICKET update_strategy non-reusable m_LOAD_TICKET_DETAIL_STG.upd_SUBHEADER_INDICATORS 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_TICKET_DETAIL_STG.EXP_BR_IND_TICKET_DETAIL_UNIQUE 1 REP_SVC_DEV EDW_POS_TICKET lookup_procedure non-reusable mplt_PRODUCT_LOOKUP_OR_ALIAS.LKP_PRODUCT_ALIAS_R4b_SIZED_PLU_ALIAS 1 REP_SVC_DEV EDW_POS_TICKET lookup_procedure non-reusable mplt_PRODUCT_LOOKUP_OR_ALIAS.LKP_PRODUCT_ALIAS_R4a_ALIAS 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_TICKET_DETAIL_STG.exp_TKT_DTL_STG_ANCHOR 1 REP_SVC_DEV EDW_POS_TICKET sessionconfig default_session_config 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_TICKET_DETAIL_STG.exp_LOOKUP_VALIDATIONS 1 REP_SVC_DEV EDW_POS_TICKET target sc_TICKET_SUBHEADER_STG 1 shortcut REP_SVC_DEV SHARED_POS_ODS target TICKET_SUBHEADER_STG 1 REP_SVC_DEV EDW_POS_TICKET lookup_procedure non-reusable m_LOAD_TICKET_DETAIL_STG.LKP_OMC_PRODUCT_SIZE_TRANSLATION 1 REP_SVC_DEV EDW_POS_TICKET expression reusable EXP_SYNTHETIC_NUM 1 REP_SVC_DEV SHARED_EDW expression reusable exp_INT_CONVERSION 1 REP_SVC_DEV EDW_POS_TICKET lookup_procedure non-reusable m_LOAD_TICKET_DETAIL_STG.lkp_VW_STORE 1 REP_SVC_DEV SHARED_POS_ODS target TICKET_DETAIL_STG 1 REP_SVC_DEV EDW_POS_TICKET custom_transformation non-reusable m_LOAD_TICKET_DETAIL_STG.JTX_CALCULATE_TKT_SBHDR_FLAGS 1 REP_SVC_DEV EDW_POS_TICKET lookup_procedure non-reusable mplt_PRODUCT_LOOKUP_OR_ALIAS.LKP_PRODUCT_ALIAS_R3_SRI_ITM_NBR 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable mplt_PRODUCT_LOOKUP_OR_ALIAS.EXP_SOURCE_ANCHOR 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_TICKET_DETAIL_STG.EXP_COLLECT_SEQ_NUM 1 REP_SVC_DEV EDW_POS_TICKET lookup_procedure non-reusable mplt_PRODUCT_LOOKUP_OR_ALIAS.LKP_PRODUCT_ALIAS_R1_BASE_PLUS_SIZE 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_TICKET_DETAIL_STG.exp_DC_RULES 1 REP_SVC_DEV EDW_POS_TICKET mapplet reusable mplt_PRODUCT_LOOKUP_OR_ALIAS 1 REP_SVC_DEV SHARED_POS_ODS source EDW_TICKET.TICKET 1 REP_SVC_DEV EDW_POS_TICKET target sc_TICKET_STG 1 shortcut REP_SVC_DEV EDW_POS_TICKET router non-reusable m_LOAD_TICKET_DETAIL_STG.RTRTRANS 1 REP_SVC_DEV EDW_POS_TICKET source EDW_TICKET.sc_TICKET_STG 1 shortcut REP_SVC_DEV EDW_POS_TICKET filter non-reusable m_LOAD_TICKET_DETAIL_STG.flt_BR_IND_TICKET_DETAIL_UNIQUE 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable mplt_PRODUCT_LOOKUP_OR_ALIAS.EXP_PRODUCT_DECISION 1 REP_SVC_DEV EDW_POS_TICKET input_transformation non-reusable mplt_PRODUCT_LOOKUP_OR_ALIAS.INPUT 1 REP_SVC_DEV EDW_POS_TICKET expression reusable sc_exp_INT_CONVERSION 1 shortcut REP_SVC_DEV SHARED_POS_ODS source EDW_TICKET.TICKET_DETAIL_AUD 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_TICKET_DETAIL_STG.EXP_PREP_PORTS_FOR_SEQ_NUM 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_TICKET_DETAIL_STG.EXP_BR_IND_TICKET_DETAIL_UNIQUE_NULL_PRIMARY_KEYS 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_TICKET_DETAIL_STG.exp_COLLECT_PORTS 1 REP_SVC_DEV EDW_POS_TICKET source EDW_TICKET.sc_TICKET 1 shortcut REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_TICKET_DETAIL_STG.exp_SOURCE_ANCHOR 1 REP_SVC_DEV EDW_POS_TICKET update_strategy non-reusable m_LOAD_TICKET_DETAIL_STG.upd_UPD_TKT_STG_AGGREGATES 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_TICKET_DETAIL_STG.exp_SALES_DATE 1 REP_SVC_DEV EDW_POS_TICKET lookup_procedure non-reusable m_LOAD_TICKET_DETAIL_STG.LKP_FIND_SUB_TICKET 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_TICKET_DETAIL_STG.exp_BR_TICKET_DETAIL_VALID 1 REP_SVC_DEV EDW_POS_TICKET source EDW_TICKET.sc_TICKET_DETAIL_AUD 1 shortcut REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_TICKET_DETAIL_STG.exp_CALCULATED_PORTS 1 REP_SVC_DEV EDW_POS_TICKET expression non-reusable m_LOAD_TICKET_DETAIL_STG.exp_MISC_DATA_VALIDATION 1 REP_SVC_DEV EDW_POS_TICKET expression reusable sc_exp_DATE_CONVERSION 1 shortcut REP_SVC_DEV SHARED_POS_ODS source EDW_TICKET.TICKET_STG 1 REP_SVC_DEV EDW_POS_TICKET session non-reusable wkf_LOAD_TICKET_DETAIL_STG.s_m_LOAD_TICKET_DETAIL_STG 1 REP_SVC_DEV EDW_POS_TICKET target sc_TICKET_DETAIL_STG 1 shortcut REP_SVC_DEV EDW_POS_TICKET lookup_procedure non-reusable mplt_PRODUCT_LOOKUP_OR_ALIAS.lkp_Get_NETSALES_EXCLUSION_FLAG 1 REP_SVC_DEV EDW_POS_TICKET workflow wkf_LOAD_TICKET_DETAIL_STG 1 . The total number of records returned: 64 listobjectdependencies completed successfully. Completed at Thu Apr 24 15:48:22 2014 |