Steps to be done on SIL_PartyOrganizationDimension failure
1. When the task SIL_PartyOrganizationDimension fails due to index creation (Post SQL), check the Informatica session log and confirm the same. Once you are sure from the log that the failure is due to duplicates during index creation, proceed to step 2.
2. Open SQL developer and connect to the Production datawarehouse (SO_BAW_PROD).
3. Once connected paste the contents of the embedded file in the SQL worksheet as shown below.
delete from W_PARTY_ORG_D_TMP t1 where exists (select 'x' from W_PARTY_ORG_D_TMP t2 where t2.DATASOURCE_NUM_ID= t1.DATASOURCE_NUM_ID and t2.INTEGRATION_ID= t1.INTEGRATION_ID and t2.rowid > t1.rowid);
create unique index W_PARTY_ORG_D_TMP_U1
on W_PARTY_ORG_D_TMP (INTEGRATION_ID,DATASOURCE_NUM_ID);
commit;
MERGE
/*+ NO_CPU_COSTING
PARALLEL
APPEND */
INTO W_PARTY_ORG_D T USING
(SELECT ROW_WID ,
GEO_WID ,
ACCNT_GEOSTATE_WID ,
ORG_NAME ,
MAIN_PH_NUM ,
ST_ADDRESS1 ,
ST_ADDRESS2 ,
ST_ADDRESS3 ,
ST_ADDRESS4 ,
POSTAL_CODE ,
CITY_NAME ,
CITY_CODE ,
STATE_NAME ,
STATE_CODE ,
COUNTRY_NAME ,
COUNTRY_CODE ,
REGION_NAME ,
REGION_CODE ,
ACTIVE_FLG ,
PROSPECT_FLG ,
SUPPLIER_FLG ,
COMPETITOR_FLG ,
ACCNT_FLG ,
ACCNT_LOC ,
CUST_STATUS_NAME ,
CUST_STATUS_CODE ,
CUST_TYPE_NAME ,
CUST_TYPE_CODE ,
CUST_CAT_NAME ,
CUST_CAT_CODE ,
ANNUAL_REVN_CAT_NAME ,
ANNUAL_REVN_CAT_CODE ,
BASE_CURCY_CD ,
BU_NAME ,
CHANNEL_FLG ,
CHNL_ANNL_SALES ,
CHNL_SALES_GRWTH_NAME ,
CHNL_SALES_GRWTH_CODE ,
DIVN_FLG ,
DIVN_TYPE_NAME ,
DIVN_TYPE_CODE ,
DOM_ULT_DUNS_NUM ,
DUNS_NUM ,
EMP_COUNT ,
EXPERTISE_NAME ,
EXPERTISE_CODE ,
FORMED_DT ,
FRGHT_TERMS_NAME ,
FRGHT_TERMS_CODE ,
GLBLULT_DUNS_NUM ,
HIST_SLS_VOL ,
LINE_OF_BUSINESS ,
NUM_EMPLOY_CAT_NAME ,
NUM_EMPLOY_CAT_CODE ,
ORG_TERR_NAME ,
ORG_FLG ,
ORG_PRTNR_FLG ,
ORG_PRTNR_TIER_NAME ,
ORG_PRTNR_TIER_CODE ,
ORG_PRTNR_TYPE_NAME ,
ORG_PRTNR_TYPE_CODE ,
PAR_DUNS_NUM ,
PAR_INTEGRATION_ID ,
PAR_ORG_NAME ,
PRI_LST_NAME ,
PRTNRSHP_START_DT ,
PRTNR_FLG ,
PRTNR_NAME ,
PRTNR_SALES_RANK ,
PR_COMPETITOR ,
PR_INDUST_NAME ,
PR_ORG_TRGT_MKT ,
PR_PTSHP_MKTSEG ,
PTNTL_SLS_VOL ,
PTSHP_END_DT ,
PTSHP_FEE_PAID_FLG ,
PTSHP_PRTNR_ACCNT ,
PTSHP_RENEWAL_DT ,
PTSHP_SAT_INDEX ,
PTSHP_STAGE_NAME ,
PTSHP_STAGE_CODE ,
PUBLIC_LISTING_FLG ,
REVN_GROWTH_CAT_NAME ,
REVN_GROWTH_CAT_CODE ,
SALES_EMP_CNT ,
SERVICE_EMP_CNT ,
ACCNT_AHA_NUM ,
ACCNT_HIN_NUM ,
CUST_CLASS_NAME ,
CUST_CLASS_CODE ,
CUST_VALUE_NAME ,
CUST_VALUE_CODE ,
AGENCY_FLG ,
AGNC_CONTRACT_DT ,
ANNUAL_REVENUE ,
BOOK_VALUE ,
BRANCH_FLG ,
CALL_FREQUENCY ,
CLIENT_FLG ,
CREDIT_SCORE ,
CRIME_TYPE_NAME ,
CRIME_TYPE_CODE ,
CURR_ASSET ,
CURR_LIAB ,
CUST_END_DT ,
CUST_SINCE_DT ,
DIVIDEND ,
EXCHANGE_LOC ,
FACILITY_FLG ,
FACILITY_TYPE_NAME ,
FACILITY_TYPE_CODE ,
FIFTYTWO_HIGH ,
FIFTYTWO_LOW ,
FIN_METHOD_NAME ,
FIN_METHOD_CODE ,
GROSS_PROFIT ,
GROWTH_HORIZ_NAME ,
GROWTH_HORIZ_CODE ,
GROWTH_OBJ_NAME ,
GROWTH_OBJ_CODE ,
GROWTH_PERCNTG ,
IDENTIFIED_DT ,
INVESTOR_FLG ,
KEY_COMPETITOR ,
LEGAL_FORM_NAME ,
LEGAL_FORM_CODE ,
LOYAL_SCORE1 ,
LOYAL_SCORE2 ,
LOYAL_SCORE3 ,
LOYAL_SCORE4 ,
LOYAL_SCORE5 ,
LOYAL_SCORE6 ,
LOYAL_SCORE7 ,
MARGIN_VS_INDUST_NAME ,
MARGIN_VS_INDUST_CODE ,
MARKET_CLASS_NAME ,
MARKET_CLASS_CODE ,
MARKET_TYPE_NAME ,
MARKET_TYPE_CODE ,
MED_PROC ,
MEMBER_NUM ,
MKT_POTENTIAL ,
MRKT_CAP_PREF_NAME ,
MRKT_CAP_PREF_CODE ,
NET_INCOME ,
NON_CASH_EXP ,
NUMB_OF_BEDS ,
OBJECTIVE_NAME ,
OBJECTIVE_CODE ,
OPER_INCOME ,
PERSIST_RATIO ,
PRIM_MARKET_NAME ,
PRIM_MARKET_CODE ,
PROJ_EPS ,
PR_SPEC_NAME ,
PR_SYN_ID ,
QUICK_RATIO ,
SHARE_OUTST ,
SRV_PROVDR_FLG ,
STAT_REASON_NAME ,
STAT_REASON_CODE ,
TICKER ,
TOTAL_DEBT ,
TOTAL_NET_WORTH ,
TOT_ASSET ,
TOT_LIABILITY ,
TRAIL_EPS ,
U_EXCH_DT ,
U_LOYAL_SCORE5 ,
VOLUME_TR ,
SIC_CODE ,
SIC_NAME ,
GOVT_ID_TYPE ,
GOVT_ID_VALUE ,
DUNNS_SITE_NAME ,
DUNNS_GLOBAL_NAME ,
DUNNS_LEGAL_NAME ,
CUSTOMER_NUM ,
ALT_CUSTOMER_NUM ,
ALT_PHONE_NUM ,
INTERNET_HOME_PAGE ,
LEGAL_STRUCT_NAME ,
LEGAL_STRUCT_CODE ,
DIRECT_MKTG_FLG ,
SOLICITATION_FLG ,
VIS_PR_BU_ID ,
VIS_PR_POS_ID ,
VIS_PR_POSTN_DH_WID ,
SETID_CUSTOMER ,
SETID_VENDOR ,
SUPPLIER_ID ,
PARENT_SUPPLIER_ID ,
SUPPLIER_NUM ,
SUPPLIER_GROUP_NAME ,
SUPPLIER_GROUP_CODE ,
SUPPLIER_CONTACT_NAME ,
SUPPLIER_TYPE_NAME ,
SUPPLIER_TYPE_CODE ,
MINORITY_GROUP_NAME ,
MINORITY_GROUP_CODE ,
SUPPLIER_SEARCH_STR ,
PREF_ORDER_METHOD ,
SUPPLIER_EXT_NETWORK_ID ,
SUPPLIER_ACTIVE_FLG ,
SUPPLIER_ONE_TIME_FLG ,
OOB_IND ,
MINORITY_OWNED_IND ,
WOMAN_OWNED_IND ,
SMALL_BUS_IND ,
YR_ESTABLISHED ,
DB_RATING ,
INTERNAL_FLG ,
FLEX_ATTRIB_1_CHAR ,
FLEX_ATTRIB_2_CHAR ,
FLEX_ATTRIB_3_CHAR ,
FLEX_ATTRIB_4_CHAR ,
FLEX_ATTRIB_5_CHAR ,
FLEX_ATTRIB_6_CHAR ,
FLEX_ATTRIB_7_CHAR ,
FLEX_ATTRIB_8_CHAR ,
FLEX_ATTRIB_9_CHAR ,
FLEX_ATTRIB_10_CHAR ,
FLEX_ATTRIB_11_CHAR ,
FLEX_ATTRIB_12_CHAR ,
FLEX_ATTRIB_13_CHAR ,
FLEX_ATTRIB_14_CHAR ,
FLEX_ATTRIB_15_CHAR ,
FLEX_ATTRIB_16_CHAR ,
FLEX_ATTRIB_17_CHAR ,
FLEX_ATTRIB_18_CHAR ,
FLEX_ATTRIB_19_CHAR ,
FLEX_ATTRIB_20_CHAR ,
CREATED_BY_WID ,
CHANGED_BY_WID ,
CREATED_ON_DT ,
CHANGED_ON_DT ,
AUX1_CHANGED_ON_DT ,
AUX2_CHANGED_ON_DT ,
AUX3_CHANGED_ON_DT ,
AUX4_CHANGED_ON_DT ,
SRC_EFF_FROM_DT ,
SRC_EFF_TO_DT ,
EFFECTIVE_FROM_DT ,
EFFECTIVE_TO_DT ,
DELETE_FLG ,
CURRENT_FLG ,
W_INSERT_DT ,
W_UPDATE_DT ,
DATASOURCE_NUM_ID ,
ETL_PROC_WID ,
INTEGRATION_ID ,
TENANT_ID ,
X_CUSTOM ,
ACCNT_REGION ,
X_COMPANY_REG_NUM
FROM W_PARTY_ORG_D_TMP
) S ON (T.INTEGRATION_ID = S.INTEGRATION_ID AND T.DATASOURCE_NUM_ID = S.DATASOURCE_NUM_ID)
WHEN MATCHED THEN
UPDATE
SET
T.GEO_WID =S.GEO_WID ,
T.ACCNT_GEOSTATE_WID =S.ACCNT_GEOSTATE_WID ,
T.ORG_NAME =S.ORG_NAME ,
T.MAIN_PH_NUM =S.MAIN_PH_NUM ,
T.ST_ADDRESS1 =S.ST_ADDRESS1 ,
T.ST_ADDRESS2 =S.ST_ADDRESS2 ,
T.ST_ADDRESS3 =S.ST_ADDRESS3 ,
T.ST_ADDRESS4 =S.ST_ADDRESS4 ,
T.POSTAL_CODE =S.POSTAL_CODE ,
T.CITY_NAME =S.CITY_NAME ,
T.CITY_CODE =S.CITY_CODE ,
T.STATE_NAME =S.STATE_NAME ,
T.STATE_CODE =S.STATE_CODE ,
T.COUNTRY_NAME =S.COUNTRY_NAME ,
T.COUNTRY_CODE =S.COUNTRY_CODE ,
T.REGION_NAME =S.REGION_NAME ,
T.REGION_CODE =S.REGION_CODE ,
T.ACTIVE_FLG =S.ACTIVE_FLG ,
T.PROSPECT_FLG =S.PROSPECT_FLG ,
T.SUPPLIER_FLG =S.SUPPLIER_FLG ,
T.COMPETITOR_FLG =S.COMPETITOR_FLG ,
T.ACCNT_FLG =S.ACCNT_FLG ,
T.ACCNT_LOC =S.ACCNT_LOC ,
T.CUST_STATUS_NAME =S.CUST_STATUS_NAME ,
T.CUST_STATUS_CODE =S.CUST_STATUS_CODE ,
T.CUST_TYPE_NAME =S.CUST_TYPE_NAME ,
T.CUST_TYPE_CODE =S.CUST_TYPE_CODE ,
T.CUST_CAT_NAME =S.CUST_CAT_NAME ,
T.CUST_CAT_CODE =S.CUST_CAT_CODE ,
T.ANNUAL_REVN_CAT_NAME =S.ANNUAL_REVN_CAT_NAME ,
T.ANNUAL_REVN_CAT_CODE =S.ANNUAL_REVN_CAT_CODE ,
T.BASE_CURCY_CD =S.BASE_CURCY_CD ,
T.BU_NAME =S.BU_NAME ,
T.CHANNEL_FLG =S.CHANNEL_FLG ,
T.CHNL_ANNL_SALES =S.CHNL_ANNL_SALES ,
T.CHNL_SALES_GRWTH_NAME =S.CHNL_SALES_GRWTH_NAME ,
T.CHNL_SALES_GRWTH_CODE =S.CHNL_SALES_GRWTH_CODE ,
T.DIVN_FLG =S.DIVN_FLG ,
T.DIVN_TYPE_NAME =S.DIVN_TYPE_NAME ,
T.DIVN_TYPE_CODE =S.DIVN_TYPE_CODE ,
T.DOM_ULT_DUNS_NUM =S.DOM_ULT_DUNS_NUM ,
T.DUNS_NUM =S.DUNS_NUM ,
T.EMP_COUNT =S.EMP_COUNT ,
T.EXPERTISE_NAME =S.EXPERTISE_NAME ,
T.EXPERTISE_CODE =S.EXPERTISE_CODE ,
T.FORMED_DT =S.FORMED_DT ,
T.FRGHT_TERMS_NAME =S.FRGHT_TERMS_NAME ,
T.FRGHT_TERMS_CODE =S.FRGHT_TERMS_CODE ,
T.GLBLULT_DUNS_NUM =S.GLBLULT_DUNS_NUM ,
T.HIST_SLS_VOL =S.HIST_SLS_VOL ,
T.LINE_OF_BUSINESS =S.LINE_OF_BUSINESS ,
T.NUM_EMPLOY_CAT_NAME =S.NUM_EMPLOY_CAT_NAME ,
T.NUM_EMPLOY_CAT_CODE =S.NUM_EMPLOY_CAT_CODE ,
T.ORG_TERR_NAME =S.ORG_TERR_NAME ,
T.ORG_FLG =S.ORG_FLG ,
T.ORG_PRTNR_FLG =S.ORG_PRTNR_FLG ,
T.ORG_PRTNR_TIER_NAME =S.ORG_PRTNR_TIER_NAME ,
T.ORG_PRTNR_TIER_CODE =S.ORG_PRTNR_TIER_CODE ,
T.ORG_PRTNR_TYPE_NAME =S.ORG_PRTNR_TYPE_NAME ,
T.ORG_PRTNR_TYPE_CODE =S.ORG_PRTNR_TYPE_CODE ,
T.PAR_DUNS_NUM =S.PAR_DUNS_NUM ,
T.PAR_INTEGRATION_ID =S.PAR_INTEGRATION_ID ,
T.PAR_ORG_NAME =S.PAR_ORG_NAME ,
T.PRI_LST_NAME =S.PRI_LST_NAME ,
T.PRTNRSHP_START_DT =S.PRTNRSHP_START_DT ,
T.PRTNR_FLG =S.PRTNR_FLG ,
T.PRTNR_NAME =S.PRTNR_NAME ,
T.PRTNR_SALES_RANK =S.PRTNR_SALES_RANK ,
T.PR_COMPETITOR =S.PR_COMPETITOR ,
T.PR_INDUST_NAME =S.PR_INDUST_NAME ,
T.PR_ORG_TRGT_MKT =S.PR_ORG_TRGT_MKT ,
T.PR_PTSHP_MKTSEG =S.PR_PTSHP_MKTSEG ,
T.PTNTL_SLS_VOL =S.PTNTL_SLS_VOL ,
T.PTSHP_END_DT =S.PTSHP_END_DT ,
T.PTSHP_FEE_PAID_FLG =S.PTSHP_FEE_PAID_FLG ,
T.PTSHP_PRTNR_ACCNT =S.PTSHP_PRTNR_ACCNT ,
T.PTSHP_RENEWAL_DT =S.PTSHP_RENEWAL_DT ,
T.PTSHP_SAT_INDEX =S.PTSHP_SAT_INDEX ,
T.PTSHP_STAGE_NAME =S.PTSHP_STAGE_NAME ,
T.PTSHP_STAGE_CODE =S.PTSHP_STAGE_CODE ,
T.PUBLIC_LISTING_FLG =S.PUBLIC_LISTING_FLG ,
T.REVN_GROWTH_CAT_NAME =S.REVN_GROWTH_CAT_NAME ,
T.REVN_GROWTH_CAT_CODE =S.REVN_GROWTH_CAT_CODE ,
T.SALES_EMP_CNT =S.SALES_EMP_CNT ,
T.SERVICE_EMP_CNT =S.SERVICE_EMP_CNT ,
T.ACCNT_AHA_NUM =S.ACCNT_AHA_NUM ,
T.ACCNT_HIN_NUM =S.ACCNT_HIN_NUM ,
T.CUST_CLASS_NAME =S.CUST_CLASS_NAME ,
T.CUST_CLASS_CODE =S.CUST_CLASS_CODE ,
T.CUST_VALUE_NAME =S.CUST_VALUE_NAME ,
T.CUST_VALUE_CODE =S.CUST_VALUE_CODE ,
T.AGENCY_FLG =S.AGENCY_FLG ,
T.AGNC_CONTRACT_DT =S.AGNC_CONTRACT_DT ,
T.ANNUAL_REVENUE =S.ANNUAL_REVENUE ,
T.BOOK_VALUE =S.BOOK_VALUE ,
T.BRANCH_FLG =S.BRANCH_FLG ,
T.CALL_FREQUENCY =S.CALL_FREQUENCY ,
T.CLIENT_FLG =S.CLIENT_FLG ,
T.CREDIT_SCORE =S.CREDIT_SCORE ,
T.CRIME_TYPE_NAME =S.CRIME_TYPE_NAME ,
T.CRIME_TYPE_CODE =S.CRIME_TYPE_CODE ,
T.CURR_ASSET =S.CURR_ASSET ,
T.CURR_LIAB =S.CURR_LIAB ,
T.CUST_END_DT =S.CUST_END_DT ,
T.CUST_SINCE_DT =S.CUST_SINCE_DT ,
T.DIVIDEND =S.DIVIDEND ,
T.EXCHANGE_LOC =S.EXCHANGE_LOC ,
T.FACILITY_FLG =S.FACILITY_FLG ,
T.FACILITY_TYPE_NAME =S.FACILITY_TYPE_NAME ,
T.FACILITY_TYPE_CODE =S.FACILITY_TYPE_CODE ,
T.FIFTYTWO_HIGH =S.FIFTYTWO_HIGH ,
T.FIFTYTWO_LOW =S.FIFTYTWO_LOW ,
T.FIN_METHOD_NAME =S.FIN_METHOD_NAME ,
T.FIN_METHOD_CODE =S.FIN_METHOD_CODE ,
T.GROSS_PROFIT =S.GROSS_PROFIT ,
T.GROWTH_HORIZ_NAME =S.GROWTH_HORIZ_NAME ,
T.GROWTH_HORIZ_CODE =S.GROWTH_HORIZ_CODE ,
T.GROWTH_OBJ_NAME =S.GROWTH_OBJ_NAME ,
T.GROWTH_OBJ_CODE =S.GROWTH_OBJ_CODE ,
T.GROWTH_PERCNTG =S.GROWTH_PERCNTG ,
T.IDENTIFIED_DT =S.IDENTIFIED_DT ,
T.INVESTOR_FLG =S.INVESTOR_FLG ,
T.KEY_COMPETITOR =S.KEY_COMPETITOR ,
T.LEGAL_FORM_NAME =S.LEGAL_FORM_NAME ,
T.LEGAL_FORM_CODE =S.LEGAL_FORM_CODE ,
T.LOYAL_SCORE1 =S.LOYAL_SCORE1 ,
T.LOYAL_SCORE2 =S.LOYAL_SCORE2 ,
T.LOYAL_SCORE3 =S.LOYAL_SCORE3 ,
T.LOYAL_SCORE4 =S.LOYAL_SCORE4 ,
T.LOYAL_SCORE5 =S.LOYAL_SCORE5 ,
T.LOYAL_SCORE6 =S.LOYAL_SCORE6 ,
T.LOYAL_SCORE7 =S.LOYAL_SCORE7 ,
T.MARGIN_VS_INDUST_NAME =S.MARGIN_VS_INDUST_NAME ,
T.MARGIN_VS_INDUST_CODE =S.MARGIN_VS_INDUST_CODE ,
T.MARKET_CLASS_NAME =S.MARKET_CLASS_NAME ,
T.MARKET_CLASS_CODE =S.MARKET_CLASS_CODE ,
T.MARKET_TYPE_NAME =S.MARKET_TYPE_NAME ,
T.MARKET_TYPE_CODE =S.MARKET_TYPE_CODE ,
T.MED_PROC =S.MED_PROC ,
T.MEMBER_NUM =S.MEMBER_NUM ,
T.MKT_POTENTIAL =S.MKT_POTENTIAL ,
T.MRKT_CAP_PREF_NAME =S.MRKT_CAP_PREF_NAME ,
T.MRKT_CAP_PREF_CODE =S.MRKT_CAP_PREF_CODE ,
T.NET_INCOME =S.NET_INCOME ,
T.NON_CASH_EXP =S.NON_CASH_EXP ,
T.NUMB_OF_BEDS =S.NUMB_OF_BEDS ,
T.OBJECTIVE_NAME =S.OBJECTIVE_NAME ,
T.OBJECTIVE_CODE =S.OBJECTIVE_CODE ,
T.OPER_INCOME =S.OPER_INCOME ,
T.PERSIST_RATIO =S.PERSIST_RATIO ,
T.PRIM_MARKET_NAME =S.PRIM_MARKET_NAME ,
T.PRIM_MARKET_CODE =S.PRIM_MARKET_CODE ,
T.PROJ_EPS =S.PROJ_EPS ,
T.PR_SPEC_NAME =S.PR_SPEC_NAME ,
T.PR_SYN_ID =S.PR_SYN_ID ,
T.QUICK_RATIO =S.QUICK_RATIO ,
T.SHARE_OUTST =S.SHARE_OUTST ,
T.SRV_PROVDR_FLG =S.SRV_PROVDR_FLG ,
T.STAT_REASON_NAME =S.STAT_REASON_NAME ,
T.STAT_REASON_CODE =S.STAT_REASON_CODE ,
T.TICKER =S.TICKER ,
T.TOTAL_DEBT =S.TOTAL_DEBT ,
T.TOTAL_NET_WORTH =S.TOTAL_NET_WORTH ,
T.TOT_ASSET =S.TOT_ASSET ,
T.TOT_LIABILITY =S.TOT_LIABILITY ,
T.TRAIL_EPS =S.TRAIL_EPS ,
T.U_EXCH_DT =S.U_EXCH_DT ,
T.U_LOYAL_SCORE5 =S.U_LOYAL_SCORE5 ,
T.VOLUME_TR =S.VOLUME_TR ,
T.SIC_CODE =S.SIC_CODE ,
T.SIC_NAME =S.SIC_NAME ,
T.GOVT_ID_TYPE =S.GOVT_ID_TYPE ,
T.GOVT_ID_VALUE =S.GOVT_ID_VALUE ,
T.DUNNS_SITE_NAME =S.DUNNS_SITE_NAME ,
T.DUNNS_GLOBAL_NAME =S.DUNNS_GLOBAL_NAME ,
T.DUNNS_LEGAL_NAME =S.DUNNS_LEGAL_NAME ,
T.CUSTOMER_NUM =S.CUSTOMER_NUM ,
T.ALT_CUSTOMER_NUM =S.ALT_CUSTOMER_NUM ,
T.ALT_PHONE_NUM =S.ALT_PHONE_NUM ,
T.INTERNET_HOME_PAGE =S.INTERNET_HOME_PAGE ,
T.LEGAL_STRUCT_NAME =S.LEGAL_STRUCT_NAME ,
T.LEGAL_STRUCT_CODE =S.LEGAL_STRUCT_CODE ,
T.DIRECT_MKTG_FLG =S.DIRECT_MKTG_FLG ,
T.SOLICITATION_FLG =S.SOLICITATION_FLG ,
T.VIS_PR_BU_ID =S.VIS_PR_BU_ID ,
T.VIS_PR_POS_ID =S.VIS_PR_POS_ID ,
T.VIS_PR_POSTN_DH_WID =S.VIS_PR_POSTN_DH_WID ,
T.SETID_CUSTOMER =S.SETID_CUSTOMER ,
T.SETID_VENDOR =S.SETID_VENDOR ,
T.SUPPLIER_ID =S.SUPPLIER_ID ,
T.PARENT_SUPPLIER_ID =S.PARENT_SUPPLIER_ID ,
T.SUPPLIER_NUM =S.SUPPLIER_NUM ,
T.SUPPLIER_GROUP_NAME =S.SUPPLIER_GROUP_NAME ,
T.SUPPLIER_GROUP_CODE =S.SUPPLIER_GROUP_CODE ,
T.SUPPLIER_CONTACT_NAME =S.SUPPLIER_CONTACT_NAME ,
T.SUPPLIER_TYPE_NAME =S.SUPPLIER_TYPE_NAME ,
T.SUPPLIER_TYPE_CODE =S.SUPPLIER_TYPE_CODE ,
T.MINORITY_GROUP_NAME =S.MINORITY_GROUP_NAME ,
T.MINORITY_GROUP_CODE =S.MINORITY_GROUP_CODE ,
T.SUPPLIER_SEARCH_STR =S.SUPPLIER_SEARCH_STR ,
T.PREF_ORDER_METHOD =S.PREF_ORDER_METHOD ,
T.SUPPLIER_EXT_NETWORK_ID =S.SUPPLIER_EXT_NETWORK_ID ,
T.SUPPLIER_ACTIVE_FLG =S.SUPPLIER_ACTIVE_FLG ,
T.SUPPLIER_ONE_TIME_FLG =S.SUPPLIER_ONE_TIME_FLG ,
T.OOB_IND =S.OOB_IND ,
T.MINORITY_OWNED_IND =S.MINORITY_OWNED_IND ,
T.WOMAN_OWNED_IND =S.WOMAN_OWNED_IND ,
T.SMALL_BUS_IND =S.SMALL_BUS_IND ,
T.YR_ESTABLISHED =S.YR_ESTABLISHED ,
T.DB_RATING =S.DB_RATING ,
T.INTERNAL_FLG =S.INTERNAL_FLG ,
T.FLEX_ATTRIB_1_CHAR =S.FLEX_ATTRIB_1_CHAR ,
T.FLEX_ATTRIB_2_CHAR =S.FLEX_ATTRIB_2_CHAR ,
T.FLEX_ATTRIB_3_CHAR =S.FLEX_ATTRIB_3_CHAR ,
T.FLEX_ATTRIB_4_CHAR =S.FLEX_ATTRIB_4_CHAR ,
T.FLEX_ATTRIB_5_CHAR =S.FLEX_ATTRIB_5_CHAR ,
T.FLEX_ATTRIB_6_CHAR =S.FLEX_ATTRIB_6_CHAR ,
T.FLEX_ATTRIB_7_CHAR =S.FLEX_ATTRIB_7_CHAR ,
T.FLEX_ATTRIB_8_CHAR =S.FLEX_ATTRIB_8_CHAR ,
T.FLEX_ATTRIB_9_CHAR =S.FLEX_ATTRIB_9_CHAR ,
T.FLEX_ATTRIB_10_CHAR =S.FLEX_ATTRIB_10_CHAR ,
T.FLEX_ATTRIB_11_CHAR =S.FLEX_ATTRIB_11_CHAR ,
T.FLEX_ATTRIB_12_CHAR =S.FLEX_ATTRIB_12_CHAR ,
T.FLEX_ATTRIB_13_CHAR =S.FLEX_ATTRIB_13_CHAR ,
T.FLEX_ATTRIB_14_CHAR =S.FLEX_ATTRIB_14_CHAR ,
T.FLEX_ATTRIB_15_CHAR =S.FLEX_ATTRIB_15_CHAR ,
T.FLEX_ATTRIB_16_CHAR =S.FLEX_ATTRIB_16_CHAR ,
T.FLEX_ATTRIB_17_CHAR =S.FLEX_ATTRIB_17_CHAR ,
T.FLEX_ATTRIB_18_CHAR =S.FLEX_ATTRIB_18_CHAR ,
T.FLEX_ATTRIB_19_CHAR =S.FLEX_ATTRIB_19_CHAR ,
T.FLEX_ATTRIB_20_CHAR =S.FLEX_ATTRIB_20_CHAR ,
T.CREATED_BY_WID =S.CREATED_BY_WID ,
T.CHANGED_BY_WID =S.CHANGED_BY_WID ,
T.CREATED_ON_DT =S.CREATED_ON_DT ,
T.CHANGED_ON_DT =S.CHANGED_ON_DT ,
T.AUX1_CHANGED_ON_DT =S.AUX1_CHANGED_ON_DT ,
T.AUX2_CHANGED_ON_DT =S.AUX2_CHANGED_ON_DT ,
T.AUX3_CHANGED_ON_DT =S.AUX3_CHANGED_ON_DT ,
T.AUX4_CHANGED_ON_DT =S.AUX4_CHANGED_ON_DT ,
T.SRC_EFF_FROM_DT =S.SRC_EFF_FROM_DT ,
T.SRC_EFF_TO_DT =S.SRC_EFF_TO_DT ,
T.EFFECTIVE_FROM_DT =S.EFFECTIVE_FROM_DT ,
T.EFFECTIVE_TO_DT =S.EFFECTIVE_TO_DT ,
T.DELETE_FLG =S.DELETE_FLG ,
T.CURRENT_FLG =S.CURRENT_FLG ,
T.W_UPDATE_DT =S.W_UPDATE_DT ,
T.ETL_PROC_WID =S.ETL_PROC_WID ,
T.TENANT_ID =S.TENANT_ID ,
T.X_CUSTOM =S.X_CUSTOM ,
T.ACCNT_REGION =S.ACCNT_REGION ,
T.X_COMPANY_REG_NUM =S.X_COMPANY_REG_NUM WHEN NOT MATCHED THEN
INSERT
(
T.ROW_WID ,
T.GEO_WID ,
T.ACCNT_GEOSTATE_WID ,
T.ORG_NAME ,
T.MAIN_PH_NUM ,
T.ST_ADDRESS1 ,
T.ST_ADDRESS2 ,
T.ST_ADDRESS3 ,
T.ST_ADDRESS4 ,
T.POSTAL_CODE ,
T.CITY_NAME ,
T.CITY_CODE ,
T.STATE_NAME ,
T.STATE_CODE ,
T.COUNTRY_NAME ,
T.COUNTRY_CODE ,
T.REGION_NAME ,
T.REGION_CODE ,
T.ACTIVE_FLG ,
T.PROSPECT_FLG ,
T.SUPPLIER_FLG ,
T.COMPETITOR_FLG ,
T.ACCNT_FLG ,
T.ACCNT_LOC ,
T.CUST_STATUS_NAME ,
T.CUST_STATUS_CODE ,
T.CUST_TYPE_NAME ,
T.CUST_TYPE_CODE ,
T.CUST_CAT_NAME ,
T.CUST_CAT_CODE ,
T.ANNUAL_REVN_CAT_NAME ,
T.ANNUAL_REVN_CAT_CODE ,
T.BASE_CURCY_CD ,
T.BU_NAME ,
T.CHANNEL_FLG ,
T.CHNL_ANNL_SALES ,
T.CHNL_SALES_GRWTH_NAME ,
T.CHNL_SALES_GRWTH_CODE ,
T.DIVN_FLG ,
T.DIVN_TYPE_NAME ,
T.DIVN_TYPE_CODE ,
T.DOM_ULT_DUNS_NUM ,
T.DUNS_NUM ,
T.EMP_COUNT ,
T.EXPERTISE_NAME ,
T.EXPERTISE_CODE ,
T.FORMED_DT ,
T.FRGHT_TERMS_NAME ,
T.FRGHT_TERMS_CODE ,
T.GLBLULT_DUNS_NUM ,
T.HIST_SLS_VOL ,
T.LINE_OF_BUSINESS ,
T.NUM_EMPLOY_CAT_NAME ,
T.NUM_EMPLOY_CAT_CODE ,
T.ORG_TERR_NAME ,
T.ORG_FLG ,
T.ORG_PRTNR_FLG ,
T.ORG_PRTNR_TIER_NAME ,
T.ORG_PRTNR_TIER_CODE ,
T.ORG_PRTNR_TYPE_NAME ,
T.ORG_PRTNR_TYPE_CODE ,
T.PAR_DUNS_NUM ,
T.PAR_INTEGRATION_ID ,
T.PAR_ORG_NAME ,
T.PRI_LST_NAME ,
T.PRTNRSHP_START_DT ,
T.PRTNR_FLG ,
T.PRTNR_NAME ,
T.PRTNR_SALES_RANK ,
T.PR_COMPETITOR ,
T.PR_INDUST_NAME ,
T.PR_ORG_TRGT_MKT ,
T.PR_PTSHP_MKTSEG ,
T.PTNTL_SLS_VOL ,
T.PTSHP_END_DT ,
T.PTSHP_FEE_PAID_FLG ,
T.PTSHP_PRTNR_ACCNT ,
T.PTSHP_RENEWAL_DT ,
T.PTSHP_SAT_INDEX ,
T.PTSHP_STAGE_NAME ,
T.PTSHP_STAGE_CODE ,
T.PUBLIC_LISTING_FLG ,
T.REVN_GROWTH_CAT_NAME ,
T.REVN_GROWTH_CAT_CODE ,
T.SALES_EMP_CNT ,
T.SERVICE_EMP_CNT ,
T.ACCNT_AHA_NUM ,
T.ACCNT_HIN_NUM ,
T.CUST_CLASS_NAME ,
T.CUST_CLASS_CODE ,
T.CUST_VALUE_NAME ,
T.CUST_VALUE_CODE ,
T.AGENCY_FLG ,
T.AGNC_CONTRACT_DT ,
T.ANNUAL_REVENUE ,
T.BOOK_VALUE ,
T.BRANCH_FLG ,
T.CALL_FREQUENCY ,
T.CLIENT_FLG ,
T.CREDIT_SCORE ,
T.CRIME_TYPE_NAME ,
T.CRIME_TYPE_CODE ,
T.CURR_ASSET ,
T.CURR_LIAB ,
T.CUST_END_DT ,
T.CUST_SINCE_DT ,
T.DIVIDEND ,
T.EXCHANGE_LOC ,
T.FACILITY_FLG ,
T.FACILITY_TYPE_NAME ,
T.FACILITY_TYPE_CODE ,
T.FIFTYTWO_HIGH ,
T.FIFTYTWO_LOW ,
T.FIN_METHOD_NAME ,
T.FIN_METHOD_CODE ,
T.GROSS_PROFIT ,
T.GROWTH_HORIZ_NAME ,
T.GROWTH_HORIZ_CODE ,
T.GROWTH_OBJ_NAME ,
T.GROWTH_OBJ_CODE ,
T.GROWTH_PERCNTG ,
T.IDENTIFIED_DT ,
T.INVESTOR_FLG ,
T.KEY_COMPETITOR ,
T.LEGAL_FORM_NAME ,
T.LEGAL_FORM_CODE ,
T.LOYAL_SCORE1 ,
T.LOYAL_SCORE2 ,
T.LOYAL_SCORE3 ,
T.LOYAL_SCORE4 ,
T.LOYAL_SCORE5 ,
T.LOYAL_SCORE6 ,
T.LOYAL_SCORE7 ,
T.MARGIN_VS_INDUST_NAME ,
T.MARGIN_VS_INDUST_CODE ,
T.MARKET_CLASS_NAME ,
T.MARKET_CLASS_CODE ,
T.MARKET_TYPE_NAME ,
T.MARKET_TYPE_CODE ,
T.MED_PROC ,
T.MEMBER_NUM ,
T.MKT_POTENTIAL ,
T.MRKT_CAP_PREF_NAME ,
T.MRKT_CAP_PREF_CODE ,
T.NET_INCOME ,
T.NON_CASH_EXP ,
T.NUMB_OF_BEDS ,
T.OBJECTIVE_NAME ,
T.OBJECTIVE_CODE ,
T.OPER_INCOME ,
T.PERSIST_RATIO ,
T.PRIM_MARKET_NAME ,
T.PRIM_MARKET_CODE ,
T.PROJ_EPS ,
T.PR_SPEC_NAME ,
T.PR_SYN_ID ,
T.QUICK_RATIO ,
T.SHARE_OUTST ,
T.SRV_PROVDR_FLG ,
T.STAT_REASON_NAME ,
T.STAT_REASON_CODE ,
T.TICKER ,
T.TOTAL_DEBT ,
T.TOTAL_NET_WORTH ,
T.TOT_ASSET ,
T.TOT_LIABILITY ,
T.TRAIL_EPS ,
T.U_EXCH_DT ,
T.U_LOYAL_SCORE5 ,
T.VOLUME_TR ,
T.SIC_CODE ,
T.SIC_NAME ,
T.GOVT_ID_TYPE ,
T.GOVT_ID_VALUE ,
T.DUNNS_SITE_NAME ,
T.DUNNS_GLOBAL_NAME ,
T.DUNNS_LEGAL_NAME ,
T.CUSTOMER_NUM ,
T.ALT_CUSTOMER_NUM ,
T.ALT_PHONE_NUM ,
T.INTERNET_HOME_PAGE ,
T.LEGAL_STRUCT_NAME ,
T.LEGAL_STRUCT_CODE ,
T.DIRECT_MKTG_FLG ,
T.SOLICITATION_FLG ,
T.VIS_PR_BU_ID ,
T.VIS_PR_POS_ID ,
T.VIS_PR_POSTN_DH_WID ,
T.SETID_CUSTOMER ,
T.SETID_VENDOR ,
T.SUPPLIER_ID ,
T.PARENT_SUPPLIER_ID ,
T.SUPPLIER_NUM ,
T.SUPPLIER_GROUP_NAME ,
T.SUPPLIER_GROUP_CODE ,
T.SUPPLIER_CONTACT_NAME ,
T.SUPPLIER_TYPE_NAME ,
T.SUPPLIER_TYPE_CODE ,
T.MINORITY_GROUP_NAME ,
T.MINORITY_GROUP_CODE ,
T.SUPPLIER_SEARCH_STR ,
T.PREF_ORDER_METHOD ,
T.SUPPLIER_EXT_NETWORK_ID ,
T.SUPPLIER_ACTIVE_FLG ,
T.SUPPLIER_ONE_TIME_FLG ,
T.OOB_IND ,
T.MINORITY_OWNED_IND ,
T.WOMAN_OWNED_IND ,
T.SMALL_BUS_IND ,
T.YR_ESTABLISHED ,
T.DB_RATING ,
T.INTERNAL_FLG ,
T.FLEX_ATTRIB_1_CHAR ,
T.FLEX_ATTRIB_2_CHAR ,
T.FLEX_ATTRIB_3_CHAR ,
T.FLEX_ATTRIB_4_CHAR ,
T.FLEX_ATTRIB_5_CHAR ,
T.FLEX_ATTRIB_6_CHAR ,
T.FLEX_ATTRIB_7_CHAR ,
T.FLEX_ATTRIB_8_CHAR ,
T.FLEX_ATTRIB_9_CHAR ,
T.FLEX_ATTRIB_10_CHAR ,
T.FLEX_ATTRIB_11_CHAR ,
T.FLEX_ATTRIB_12_CHAR ,
T.FLEX_ATTRIB_13_CHAR ,
T.FLEX_ATTRIB_14_CHAR ,
T.FLEX_ATTRIB_15_CHAR ,
T.FLEX_ATTRIB_16_CHAR ,
T.FLEX_ATTRIB_17_CHAR ,
T.FLEX_ATTRIB_18_CHAR ,
T.FLEX_ATTRIB_19_CHAR ,
T.FLEX_ATTRIB_20_CHAR ,
T.CREATED_BY_WID ,
T.CHANGED_BY_WID ,
T.CREATED_ON_DT ,
T.CHANGED_ON_DT ,
T.AUX1_CHANGED_ON_DT ,
T.AUX2_CHANGED_ON_DT ,
T.AUX3_CHANGED_ON_DT ,
T.AUX4_CHANGED_ON_DT ,
T.SRC_EFF_FROM_DT ,
T.SRC_EFF_TO_DT ,
T.EFFECTIVE_FROM_DT ,
T.EFFECTIVE_TO_DT ,
T.DELETE_FLG ,
T.CURRENT_FLG ,
T.W_INSERT_DT ,
T.W_UPDATE_DT ,
T.DATASOURCE_NUM_ID ,
T.ETL_PROC_WID ,
T.INTEGRATION_ID ,
T.TENANT_ID ,
T.X_CUSTOM ,
T.ACCNT_REGION ,
T.X_COMPANY_REG_NUM
)
VALUES
(
S.ROW_WID ,
S.GEO_WID ,
S.ACCNT_GEOSTATE_WID ,
S.ORG_NAME ,
S.MAIN_PH_NUM ,
S.ST_ADDRESS1 ,
S.ST_ADDRESS2 ,
S.ST_ADDRESS3 ,
S.ST_ADDRESS4 ,
S.POSTAL_CODE ,
S.CITY_NAME ,
S.CITY_CODE ,
S.STATE_NAME ,
S.STATE_CODE ,
S.COUNTRY_NAME ,
S.COUNTRY_CODE ,
S.REGION_NAME ,
S.REGION_CODE ,
S.ACTIVE_FLG ,
S.PROSPECT_FLG ,
S.SUPPLIER_FLG ,
S.COMPETITOR_FLG ,
S.ACCNT_FLG ,
S.ACCNT_LOC ,
S.CUST_STATUS_NAME ,
S.CUST_STATUS_CODE ,
S.CUST_TYPE_NAME ,
S.CUST_TYPE_CODE ,
S.CUST_CAT_NAME ,
S.CUST_CAT_CODE ,
S.ANNUAL_REVN_CAT_NAME ,
S.ANNUAL_REVN_CAT_CODE ,
S.BASE_CURCY_CD ,
S.BU_NAME ,
S.CHANNEL_FLG ,
S.CHNL_ANNL_SALES ,
S.CHNL_SALES_GRWTH_NAME ,
S.CHNL_SALES_GRWTH_CODE ,
S.DIVN_FLG ,
S.DIVN_TYPE_NAME ,
S.DIVN_TYPE_CODE ,
S.DOM_ULT_DUNS_NUM ,
S.DUNS_NUM ,
S.EMP_COUNT ,
S.EXPERTISE_NAME ,
S.EXPERTISE_CODE ,
S.FORMED_DT ,
S.FRGHT_TERMS_NAME ,
S.FRGHT_TERMS_CODE ,
S.GLBLULT_DUNS_NUM ,
S.HIST_SLS_VOL ,
S.LINE_OF_BUSINESS ,
S.NUM_EMPLOY_CAT_NAME ,
S.NUM_EMPLOY_CAT_CODE ,
S.ORG_TERR_NAME ,
S.ORG_FLG ,
S.ORG_PRTNR_FLG ,
S.ORG_PRTNR_TIER_NAME ,
S.ORG_PRTNR_TIER_CODE ,
S.ORG_PRTNR_TYPE_NAME ,
S.ORG_PRTNR_TYPE_CODE ,
S.PAR_DUNS_NUM ,
S.PAR_INTEGRATION_ID ,
S.PAR_ORG_NAME ,
S.PRI_LST_NAME ,
S.PRTNRSHP_START_DT ,
S.PRTNR_FLG ,
S.PRTNR_NAME ,
S.PRTNR_SALES_RANK ,
S.PR_COMPETITOR ,
S.PR_INDUST_NAME ,
S.PR_ORG_TRGT_MKT ,
S.PR_PTSHP_MKTSEG ,
S.PTNTL_SLS_VOL ,
S.PTSHP_END_DT ,
S.PTSHP_FEE_PAID_FLG ,
S.PTSHP_PRTNR_ACCNT ,
S.PTSHP_RENEWAL_DT ,
S.PTSHP_SAT_INDEX ,
S.PTSHP_STAGE_NAME ,
S.PTSHP_STAGE_CODE ,
S.PUBLIC_LISTING_FLG ,
S.REVN_GROWTH_CAT_NAME ,
S.REVN_GROWTH_CAT_CODE ,
S.SALES_EMP_CNT ,
S.SERVICE_EMP_CNT ,
S.ACCNT_AHA_NUM ,
S.ACCNT_HIN_NUM ,
S.CUST_CLASS_NAME ,
S.CUST_CLASS_CODE ,
S.CUST_VALUE_NAME ,
S.CUST_VALUE_CODE ,
S.AGENCY_FLG ,
S.AGNC_CONTRACT_DT ,
S.ANNUAL_REVENUE ,
S.BOOK_VALUE ,
S.BRANCH_FLG ,
S.CALL_FREQUENCY ,
S.CLIENT_FLG ,
S.CREDIT_SCORE ,
S.CRIME_TYPE_NAME ,
S.CRIME_TYPE_CODE ,
S.CURR_ASSET ,
S.CURR_LIAB ,
S.CUST_END_DT ,
S.CUST_SINCE_DT ,
S.DIVIDEND ,
S.EXCHANGE_LOC ,
S.FACILITY_FLG ,
S.FACILITY_TYPE_NAME ,
S.FACILITY_TYPE_CODE ,
S.FIFTYTWO_HIGH ,
S.FIFTYTWO_LOW ,
S.FIN_METHOD_NAME ,
S.FIN_METHOD_CODE ,
S.GROSS_PROFIT ,
S.GROWTH_HORIZ_NAME ,
S.GROWTH_HORIZ_CODE ,
S.GROWTH_OBJ_NAME ,
S.GROWTH_OBJ_CODE ,
S.GROWTH_PERCNTG ,
S.IDENTIFIED_DT ,
S.INVESTOR_FLG ,
S.KEY_COMPETITOR ,
S.LEGAL_FORM_NAME ,
S.LEGAL_FORM_CODE ,
S.LOYAL_SCORE1 ,
S.LOYAL_SCORE2 ,
S.LOYAL_SCORE3 ,
S.LOYAL_SCORE4 ,
S.LOYAL_SCORE5 ,
S.LOYAL_SCORE6 ,
S.LOYAL_SCORE7 ,
S.MARGIN_VS_INDUST_NAME ,
S.MARGIN_VS_INDUST_CODE ,
S.MARKET_CLASS_NAME ,
S.MARKET_CLASS_CODE ,
S.MARKET_TYPE_NAME ,
S.MARKET_TYPE_CODE ,
S.MED_PROC ,
S.MEMBER_NUM ,
S.MKT_POTENTIAL ,
S.MRKT_CAP_PREF_NAME ,
S.MRKT_CAP_PREF_CODE ,
S.NET_INCOME ,
S.NON_CASH_EXP ,
S.NUMB_OF_BEDS ,
S.OBJECTIVE_NAME ,
S.OBJECTIVE_CODE ,
S.OPER_INCOME ,
S.PERSIST_RATIO ,
S.PRIM_MARKET_NAME ,
S.PRIM_MARKET_CODE ,
S.PROJ_EPS ,
S.PR_SPEC_NAME ,
S.PR_SYN_ID ,
S.QUICK_RATIO ,
S.SHARE_OUTST ,
S.SRV_PROVDR_FLG ,
S.STAT_REASON_NAME ,
S.STAT_REASON_CODE ,
S.TICKER ,
S.TOTAL_DEBT ,
S.TOTAL_NET_WORTH ,
S.TOT_ASSET ,
S.TOT_LIABILITY ,
S.TRAIL_EPS ,
S.U_EXCH_DT ,
S.U_LOYAL_SCORE5 ,
S.VOLUME_TR ,
S.SIC_CODE ,
S.SIC_NAME ,
S.GOVT_ID_TYPE ,
S.GOVT_ID_VALUE ,
S.DUNNS_SITE_NAME ,
S.DUNNS_GLOBAL_NAME ,
S.DUNNS_LEGAL_NAME ,
S.CUSTOMER_NUM ,
S.ALT_CUSTOMER_NUM ,
S.ALT_PHONE_NUM ,
S.INTERNET_HOME_PAGE ,
S.LEGAL_STRUCT_NAME ,
S.LEGAL_STRUCT_CODE ,
S.DIRECT_MKTG_FLG ,
S.SOLICITATION_FLG ,
S.VIS_PR_BU_ID ,
S.VIS_PR_POS_ID ,
S.VIS_PR_POSTN_DH_WID ,
S.SETID_CUSTOMER ,
S.SETID_VENDOR ,
S.SUPPLIER_ID ,
S.PARENT_SUPPLIER_ID ,
S.SUPPLIER_NUM ,
S.SUPPLIER_GROUP_NAME ,
S.SUPPLIER_GROUP_CODE ,
S.SUPPLIER_CONTACT_NAME ,
S.SUPPLIER_TYPE_NAME ,
S.SUPPLIER_TYPE_CODE ,
S.MINORITY_GROUP_NAME ,
S.MINORITY_GROUP_CODE ,
S.SUPPLIER_SEARCH_STR ,
S.PREF_ORDER_METHOD ,
S.SUPPLIER_EXT_NETWORK_ID ,
S.SUPPLIER_ACTIVE_FLG ,
S.SUPPLIER_ONE_TIME_FLG ,
S.OOB_IND ,
S.MINORITY_OWNED_IND ,
S.WOMAN_OWNED_IND ,
S.SMALL_BUS_IND ,
S.YR_ESTABLISHED ,
S.DB_RATING ,
S.INTERNAL_FLG ,
S.FLEX_ATTRIB_1_CHAR ,
S.FLEX_ATTRIB_2_CHAR ,
S.FLEX_ATTRIB_3_CHAR ,
S.FLEX_ATTRIB_4_CHAR ,
S.FLEX_ATTRIB_5_CHAR ,
S.FLEX_ATTRIB_6_CHAR ,
S.FLEX_ATTRIB_7_CHAR ,
S.FLEX_ATTRIB_8_CHAR ,
S.FLEX_ATTRIB_9_CHAR ,
S.FLEX_ATTRIB_10_CHAR ,
S.FLEX_ATTRIB_11_CHAR ,
S.FLEX_ATTRIB_12_CHAR ,
S.FLEX_ATTRIB_13_CHAR ,
S.FLEX_ATTRIB_14_CHAR ,
S.FLEX_ATTRIB_15_CHAR ,
S.FLEX_ATTRIB_16_CHAR ,
S.FLEX_ATTRIB_17_CHAR ,
S.FLEX_ATTRIB_18_CHAR ,
S.FLEX_ATTRIB_19_CHAR ,
S.FLEX_ATTRIB_20_CHAR ,
S.CREATED_BY_WID ,
S.CHANGED_BY_WID ,
S.CREATED_ON_DT ,
S.CHANGED_ON_DT ,
S.AUX1_CHANGED_ON_DT ,
S.AUX2_CHANGED_ON_DT ,
S.AUX3_CHANGED_ON_DT ,
S.AUX4_CHANGED_ON_DT ,
S.SRC_EFF_FROM_DT ,
S.SRC_EFF_TO_DT ,
S.EFFECTIVE_FROM_DT ,
S.EFFECTIVE_TO_DT ,
S.DELETE_FLG ,
S.CURRENT_FLG ,
S.W_INSERT_DT ,
S.W_UPDATE_DT ,
S.DATASOURCE_NUM_ID ,
S.ETL_PROC_WID ,
S.INTEGRATION_ID ,
S.TENANT_ID ,
S.X_CUSTOM ,
S.ACCNT_REGION ,
S.X_COMPANY_REG_NUM
);
commit;
4. Once done, execute the entire worksheet by clicking on the RunScript
button or F5 key.
5. When all the three queries (Delete, Index creation and Merge) are successfully executed, open DAC and login to the Prod environment.
6. In Execute section, open the current runs tab in the top pane and Tasks in the bottom pane.
7. In the bottom pane, select failed from the dropdown instead of all.
8. When selected, the failed SIL_PartyOrganizationDimension task will be shown. In that, under Task Status click on the text failed. It will open as a drop down, set it to Completed. Then click save button in the bottom pane as shown in the screenshot below.
9. Then if the load is still running, leave it as such as the load will continue. Else if the entire load is failed (ie., in the current runs tab, the load will have the Run Status as Failed), Click on the Restart button.
10. Once clicked, the load will continue from the next task to run.
Note: This procedure applies to any task failure irrespective of the loads except for the steps involving execution of the post SQL in Data Warehouse.
1. When the task SIL_PartyOrganizationDimension fails due to index creation (Post SQL), check the Informatica session log and confirm the same. Once you are sure from the log that the failure is due to duplicates during index creation, proceed to step 2.
2. Open SQL developer and connect to the Production datawarehouse (SO_BAW_PROD).
3. Once connected paste the contents of the embedded file in the SQL worksheet as shown below.
delete from W_PARTY_ORG_D_TMP t1 where exists (select 'x' from W_PARTY_ORG_D_TMP t2 where t2.DATASOURCE_NUM_ID= t1.DATASOURCE_NUM_ID and t2.INTEGRATION_ID= t1.INTEGRATION_ID and t2.rowid > t1.rowid);
create unique index W_PARTY_ORG_D_TMP_U1
on W_PARTY_ORG_D_TMP (INTEGRATION_ID,DATASOURCE_NUM_ID);
commit;
MERGE
/*+ NO_CPU_COSTING
PARALLEL
APPEND */
INTO W_PARTY_ORG_D T USING
(SELECT ROW_WID ,
GEO_WID ,
ACCNT_GEOSTATE_WID ,
ORG_NAME ,
MAIN_PH_NUM ,
ST_ADDRESS1 ,
ST_ADDRESS2 ,
ST_ADDRESS3 ,
ST_ADDRESS4 ,
POSTAL_CODE ,
CITY_NAME ,
CITY_CODE ,
STATE_NAME ,
STATE_CODE ,
COUNTRY_NAME ,
COUNTRY_CODE ,
REGION_NAME ,
REGION_CODE ,
ACTIVE_FLG ,
PROSPECT_FLG ,
SUPPLIER_FLG ,
COMPETITOR_FLG ,
ACCNT_FLG ,
ACCNT_LOC ,
CUST_STATUS_NAME ,
CUST_STATUS_CODE ,
CUST_TYPE_NAME ,
CUST_TYPE_CODE ,
CUST_CAT_NAME ,
CUST_CAT_CODE ,
ANNUAL_REVN_CAT_NAME ,
ANNUAL_REVN_CAT_CODE ,
BASE_CURCY_CD ,
BU_NAME ,
CHANNEL_FLG ,
CHNL_ANNL_SALES ,
CHNL_SALES_GRWTH_NAME ,
CHNL_SALES_GRWTH_CODE ,
DIVN_FLG ,
DIVN_TYPE_NAME ,
DIVN_TYPE_CODE ,
DOM_ULT_DUNS_NUM ,
DUNS_NUM ,
EMP_COUNT ,
EXPERTISE_NAME ,
EXPERTISE_CODE ,
FORMED_DT ,
FRGHT_TERMS_NAME ,
FRGHT_TERMS_CODE ,
GLBLULT_DUNS_NUM ,
HIST_SLS_VOL ,
LINE_OF_BUSINESS ,
NUM_EMPLOY_CAT_NAME ,
NUM_EMPLOY_CAT_CODE ,
ORG_TERR_NAME ,
ORG_FLG ,
ORG_PRTNR_FLG ,
ORG_PRTNR_TIER_NAME ,
ORG_PRTNR_TIER_CODE ,
ORG_PRTNR_TYPE_NAME ,
ORG_PRTNR_TYPE_CODE ,
PAR_DUNS_NUM ,
PAR_INTEGRATION_ID ,
PAR_ORG_NAME ,
PRI_LST_NAME ,
PRTNRSHP_START_DT ,
PRTNR_FLG ,
PRTNR_NAME ,
PRTNR_SALES_RANK ,
PR_COMPETITOR ,
PR_INDUST_NAME ,
PR_ORG_TRGT_MKT ,
PR_PTSHP_MKTSEG ,
PTNTL_SLS_VOL ,
PTSHP_END_DT ,
PTSHP_FEE_PAID_FLG ,
PTSHP_PRTNR_ACCNT ,
PTSHP_RENEWAL_DT ,
PTSHP_SAT_INDEX ,
PTSHP_STAGE_NAME ,
PTSHP_STAGE_CODE ,
PUBLIC_LISTING_FLG ,
REVN_GROWTH_CAT_NAME ,
REVN_GROWTH_CAT_CODE ,
SALES_EMP_CNT ,
SERVICE_EMP_CNT ,
ACCNT_AHA_NUM ,
ACCNT_HIN_NUM ,
CUST_CLASS_NAME ,
CUST_CLASS_CODE ,
CUST_VALUE_NAME ,
CUST_VALUE_CODE ,
AGENCY_FLG ,
AGNC_CONTRACT_DT ,
ANNUAL_REVENUE ,
BOOK_VALUE ,
BRANCH_FLG ,
CALL_FREQUENCY ,
CLIENT_FLG ,
CREDIT_SCORE ,
CRIME_TYPE_NAME ,
CRIME_TYPE_CODE ,
CURR_ASSET ,
CURR_LIAB ,
CUST_END_DT ,
CUST_SINCE_DT ,
DIVIDEND ,
EXCHANGE_LOC ,
FACILITY_FLG ,
FACILITY_TYPE_NAME ,
FACILITY_TYPE_CODE ,
FIFTYTWO_HIGH ,
FIFTYTWO_LOW ,
FIN_METHOD_NAME ,
FIN_METHOD_CODE ,
GROSS_PROFIT ,
GROWTH_HORIZ_NAME ,
GROWTH_HORIZ_CODE ,
GROWTH_OBJ_NAME ,
GROWTH_OBJ_CODE ,
GROWTH_PERCNTG ,
IDENTIFIED_DT ,
INVESTOR_FLG ,
KEY_COMPETITOR ,
LEGAL_FORM_NAME ,
LEGAL_FORM_CODE ,
LOYAL_SCORE1 ,
LOYAL_SCORE2 ,
LOYAL_SCORE3 ,
LOYAL_SCORE4 ,
LOYAL_SCORE5 ,
LOYAL_SCORE6 ,
LOYAL_SCORE7 ,
MARGIN_VS_INDUST_NAME ,
MARGIN_VS_INDUST_CODE ,
MARKET_CLASS_NAME ,
MARKET_CLASS_CODE ,
MARKET_TYPE_NAME ,
MARKET_TYPE_CODE ,
MED_PROC ,
MEMBER_NUM ,
MKT_POTENTIAL ,
MRKT_CAP_PREF_NAME ,
MRKT_CAP_PREF_CODE ,
NET_INCOME ,
NON_CASH_EXP ,
NUMB_OF_BEDS ,
OBJECTIVE_NAME ,
OBJECTIVE_CODE ,
OPER_INCOME ,
PERSIST_RATIO ,
PRIM_MARKET_NAME ,
PRIM_MARKET_CODE ,
PROJ_EPS ,
PR_SPEC_NAME ,
PR_SYN_ID ,
QUICK_RATIO ,
SHARE_OUTST ,
SRV_PROVDR_FLG ,
STAT_REASON_NAME ,
STAT_REASON_CODE ,
TICKER ,
TOTAL_DEBT ,
TOTAL_NET_WORTH ,
TOT_ASSET ,
TOT_LIABILITY ,
TRAIL_EPS ,
U_EXCH_DT ,
U_LOYAL_SCORE5 ,
VOLUME_TR ,
SIC_CODE ,
SIC_NAME ,
GOVT_ID_TYPE ,
GOVT_ID_VALUE ,
DUNNS_SITE_NAME ,
DUNNS_GLOBAL_NAME ,
DUNNS_LEGAL_NAME ,
CUSTOMER_NUM ,
ALT_CUSTOMER_NUM ,
ALT_PHONE_NUM ,
INTERNET_HOME_PAGE ,
LEGAL_STRUCT_NAME ,
LEGAL_STRUCT_CODE ,
DIRECT_MKTG_FLG ,
SOLICITATION_FLG ,
VIS_PR_BU_ID ,
VIS_PR_POS_ID ,
VIS_PR_POSTN_DH_WID ,
SETID_CUSTOMER ,
SETID_VENDOR ,
SUPPLIER_ID ,
PARENT_SUPPLIER_ID ,
SUPPLIER_NUM ,
SUPPLIER_GROUP_NAME ,
SUPPLIER_GROUP_CODE ,
SUPPLIER_CONTACT_NAME ,
SUPPLIER_TYPE_NAME ,
SUPPLIER_TYPE_CODE ,
MINORITY_GROUP_NAME ,
MINORITY_GROUP_CODE ,
SUPPLIER_SEARCH_STR ,
PREF_ORDER_METHOD ,
SUPPLIER_EXT_NETWORK_ID ,
SUPPLIER_ACTIVE_FLG ,
SUPPLIER_ONE_TIME_FLG ,
OOB_IND ,
MINORITY_OWNED_IND ,
WOMAN_OWNED_IND ,
SMALL_BUS_IND ,
YR_ESTABLISHED ,
DB_RATING ,
INTERNAL_FLG ,
FLEX_ATTRIB_1_CHAR ,
FLEX_ATTRIB_2_CHAR ,
FLEX_ATTRIB_3_CHAR ,
FLEX_ATTRIB_4_CHAR ,
FLEX_ATTRIB_5_CHAR ,
FLEX_ATTRIB_6_CHAR ,
FLEX_ATTRIB_7_CHAR ,
FLEX_ATTRIB_8_CHAR ,
FLEX_ATTRIB_9_CHAR ,
FLEX_ATTRIB_10_CHAR ,
FLEX_ATTRIB_11_CHAR ,
FLEX_ATTRIB_12_CHAR ,
FLEX_ATTRIB_13_CHAR ,
FLEX_ATTRIB_14_CHAR ,
FLEX_ATTRIB_15_CHAR ,
FLEX_ATTRIB_16_CHAR ,
FLEX_ATTRIB_17_CHAR ,
FLEX_ATTRIB_18_CHAR ,
FLEX_ATTRIB_19_CHAR ,
FLEX_ATTRIB_20_CHAR ,
CREATED_BY_WID ,
CHANGED_BY_WID ,
CREATED_ON_DT ,
CHANGED_ON_DT ,
AUX1_CHANGED_ON_DT ,
AUX2_CHANGED_ON_DT ,
AUX3_CHANGED_ON_DT ,
AUX4_CHANGED_ON_DT ,
SRC_EFF_FROM_DT ,
SRC_EFF_TO_DT ,
EFFECTIVE_FROM_DT ,
EFFECTIVE_TO_DT ,
DELETE_FLG ,
CURRENT_FLG ,
W_INSERT_DT ,
W_UPDATE_DT ,
DATASOURCE_NUM_ID ,
ETL_PROC_WID ,
INTEGRATION_ID ,
TENANT_ID ,
X_CUSTOM ,
ACCNT_REGION ,
X_COMPANY_REG_NUM
FROM W_PARTY_ORG_D_TMP
) S ON (T.INTEGRATION_ID = S.INTEGRATION_ID AND T.DATASOURCE_NUM_ID = S.DATASOURCE_NUM_ID)
WHEN MATCHED THEN
UPDATE
SET
T.GEO_WID =S.GEO_WID ,
T.ACCNT_GEOSTATE_WID =S.ACCNT_GEOSTATE_WID ,
T.ORG_NAME =S.ORG_NAME ,
T.MAIN_PH_NUM =S.MAIN_PH_NUM ,
T.ST_ADDRESS1 =S.ST_ADDRESS1 ,
T.ST_ADDRESS2 =S.ST_ADDRESS2 ,
T.ST_ADDRESS3 =S.ST_ADDRESS3 ,
T.ST_ADDRESS4 =S.ST_ADDRESS4 ,
T.POSTAL_CODE =S.POSTAL_CODE ,
T.CITY_NAME =S.CITY_NAME ,
T.CITY_CODE =S.CITY_CODE ,
T.STATE_NAME =S.STATE_NAME ,
T.STATE_CODE =S.STATE_CODE ,
T.COUNTRY_NAME =S.COUNTRY_NAME ,
T.COUNTRY_CODE =S.COUNTRY_CODE ,
T.REGION_NAME =S.REGION_NAME ,
T.REGION_CODE =S.REGION_CODE ,
T.ACTIVE_FLG =S.ACTIVE_FLG ,
T.PROSPECT_FLG =S.PROSPECT_FLG ,
T.SUPPLIER_FLG =S.SUPPLIER_FLG ,
T.COMPETITOR_FLG =S.COMPETITOR_FLG ,
T.ACCNT_FLG =S.ACCNT_FLG ,
T.ACCNT_LOC =S.ACCNT_LOC ,
T.CUST_STATUS_NAME =S.CUST_STATUS_NAME ,
T.CUST_STATUS_CODE =S.CUST_STATUS_CODE ,
T.CUST_TYPE_NAME =S.CUST_TYPE_NAME ,
T.CUST_TYPE_CODE =S.CUST_TYPE_CODE ,
T.CUST_CAT_NAME =S.CUST_CAT_NAME ,
T.CUST_CAT_CODE =S.CUST_CAT_CODE ,
T.ANNUAL_REVN_CAT_NAME =S.ANNUAL_REVN_CAT_NAME ,
T.ANNUAL_REVN_CAT_CODE =S.ANNUAL_REVN_CAT_CODE ,
T.BASE_CURCY_CD =S.BASE_CURCY_CD ,
T.BU_NAME =S.BU_NAME ,
T.CHANNEL_FLG =S.CHANNEL_FLG ,
T.CHNL_ANNL_SALES =S.CHNL_ANNL_SALES ,
T.CHNL_SALES_GRWTH_NAME =S.CHNL_SALES_GRWTH_NAME ,
T.CHNL_SALES_GRWTH_CODE =S.CHNL_SALES_GRWTH_CODE ,
T.DIVN_FLG =S.DIVN_FLG ,
T.DIVN_TYPE_NAME =S.DIVN_TYPE_NAME ,
T.DIVN_TYPE_CODE =S.DIVN_TYPE_CODE ,
T.DOM_ULT_DUNS_NUM =S.DOM_ULT_DUNS_NUM ,
T.DUNS_NUM =S.DUNS_NUM ,
T.EMP_COUNT =S.EMP_COUNT ,
T.EXPERTISE_NAME =S.EXPERTISE_NAME ,
T.EXPERTISE_CODE =S.EXPERTISE_CODE ,
T.FORMED_DT =S.FORMED_DT ,
T.FRGHT_TERMS_NAME =S.FRGHT_TERMS_NAME ,
T.FRGHT_TERMS_CODE =S.FRGHT_TERMS_CODE ,
T.GLBLULT_DUNS_NUM =S.GLBLULT_DUNS_NUM ,
T.HIST_SLS_VOL =S.HIST_SLS_VOL ,
T.LINE_OF_BUSINESS =S.LINE_OF_BUSINESS ,
T.NUM_EMPLOY_CAT_NAME =S.NUM_EMPLOY_CAT_NAME ,
T.NUM_EMPLOY_CAT_CODE =S.NUM_EMPLOY_CAT_CODE ,
T.ORG_TERR_NAME =S.ORG_TERR_NAME ,
T.ORG_FLG =S.ORG_FLG ,
T.ORG_PRTNR_FLG =S.ORG_PRTNR_FLG ,
T.ORG_PRTNR_TIER_NAME =S.ORG_PRTNR_TIER_NAME ,
T.ORG_PRTNR_TIER_CODE =S.ORG_PRTNR_TIER_CODE ,
T.ORG_PRTNR_TYPE_NAME =S.ORG_PRTNR_TYPE_NAME ,
T.ORG_PRTNR_TYPE_CODE =S.ORG_PRTNR_TYPE_CODE ,
T.PAR_DUNS_NUM =S.PAR_DUNS_NUM ,
T.PAR_INTEGRATION_ID =S.PAR_INTEGRATION_ID ,
T.PAR_ORG_NAME =S.PAR_ORG_NAME ,
T.PRI_LST_NAME =S.PRI_LST_NAME ,
T.PRTNRSHP_START_DT =S.PRTNRSHP_START_DT ,
T.PRTNR_FLG =S.PRTNR_FLG ,
T.PRTNR_NAME =S.PRTNR_NAME ,
T.PRTNR_SALES_RANK =S.PRTNR_SALES_RANK ,
T.PR_COMPETITOR =S.PR_COMPETITOR ,
T.PR_INDUST_NAME =S.PR_INDUST_NAME ,
T.PR_ORG_TRGT_MKT =S.PR_ORG_TRGT_MKT ,
T.PR_PTSHP_MKTSEG =S.PR_PTSHP_MKTSEG ,
T.PTNTL_SLS_VOL =S.PTNTL_SLS_VOL ,
T.PTSHP_END_DT =S.PTSHP_END_DT ,
T.PTSHP_FEE_PAID_FLG =S.PTSHP_FEE_PAID_FLG ,
T.PTSHP_PRTNR_ACCNT =S.PTSHP_PRTNR_ACCNT ,
T.PTSHP_RENEWAL_DT =S.PTSHP_RENEWAL_DT ,
T.PTSHP_SAT_INDEX =S.PTSHP_SAT_INDEX ,
T.PTSHP_STAGE_NAME =S.PTSHP_STAGE_NAME ,
T.PTSHP_STAGE_CODE =S.PTSHP_STAGE_CODE ,
T.PUBLIC_LISTING_FLG =S.PUBLIC_LISTING_FLG ,
T.REVN_GROWTH_CAT_NAME =S.REVN_GROWTH_CAT_NAME ,
T.REVN_GROWTH_CAT_CODE =S.REVN_GROWTH_CAT_CODE ,
T.SALES_EMP_CNT =S.SALES_EMP_CNT ,
T.SERVICE_EMP_CNT =S.SERVICE_EMP_CNT ,
T.ACCNT_AHA_NUM =S.ACCNT_AHA_NUM ,
T.ACCNT_HIN_NUM =S.ACCNT_HIN_NUM ,
T.CUST_CLASS_NAME =S.CUST_CLASS_NAME ,
T.CUST_CLASS_CODE =S.CUST_CLASS_CODE ,
T.CUST_VALUE_NAME =S.CUST_VALUE_NAME ,
T.CUST_VALUE_CODE =S.CUST_VALUE_CODE ,
T.AGENCY_FLG =S.AGENCY_FLG ,
T.AGNC_CONTRACT_DT =S.AGNC_CONTRACT_DT ,
T.ANNUAL_REVENUE =S.ANNUAL_REVENUE ,
T.BOOK_VALUE =S.BOOK_VALUE ,
T.BRANCH_FLG =S.BRANCH_FLG ,
T.CALL_FREQUENCY =S.CALL_FREQUENCY ,
T.CLIENT_FLG =S.CLIENT_FLG ,
T.CREDIT_SCORE =S.CREDIT_SCORE ,
T.CRIME_TYPE_NAME =S.CRIME_TYPE_NAME ,
T.CRIME_TYPE_CODE =S.CRIME_TYPE_CODE ,
T.CURR_ASSET =S.CURR_ASSET ,
T.CURR_LIAB =S.CURR_LIAB ,
T.CUST_END_DT =S.CUST_END_DT ,
T.CUST_SINCE_DT =S.CUST_SINCE_DT ,
T.DIVIDEND =S.DIVIDEND ,
T.EXCHANGE_LOC =S.EXCHANGE_LOC ,
T.FACILITY_FLG =S.FACILITY_FLG ,
T.FACILITY_TYPE_NAME =S.FACILITY_TYPE_NAME ,
T.FACILITY_TYPE_CODE =S.FACILITY_TYPE_CODE ,
T.FIFTYTWO_HIGH =S.FIFTYTWO_HIGH ,
T.FIFTYTWO_LOW =S.FIFTYTWO_LOW ,
T.FIN_METHOD_NAME =S.FIN_METHOD_NAME ,
T.FIN_METHOD_CODE =S.FIN_METHOD_CODE ,
T.GROSS_PROFIT =S.GROSS_PROFIT ,
T.GROWTH_HORIZ_NAME =S.GROWTH_HORIZ_NAME ,
T.GROWTH_HORIZ_CODE =S.GROWTH_HORIZ_CODE ,
T.GROWTH_OBJ_NAME =S.GROWTH_OBJ_NAME ,
T.GROWTH_OBJ_CODE =S.GROWTH_OBJ_CODE ,
T.GROWTH_PERCNTG =S.GROWTH_PERCNTG ,
T.IDENTIFIED_DT =S.IDENTIFIED_DT ,
T.INVESTOR_FLG =S.INVESTOR_FLG ,
T.KEY_COMPETITOR =S.KEY_COMPETITOR ,
T.LEGAL_FORM_NAME =S.LEGAL_FORM_NAME ,
T.LEGAL_FORM_CODE =S.LEGAL_FORM_CODE ,
T.LOYAL_SCORE1 =S.LOYAL_SCORE1 ,
T.LOYAL_SCORE2 =S.LOYAL_SCORE2 ,
T.LOYAL_SCORE3 =S.LOYAL_SCORE3 ,
T.LOYAL_SCORE4 =S.LOYAL_SCORE4 ,
T.LOYAL_SCORE5 =S.LOYAL_SCORE5 ,
T.LOYAL_SCORE6 =S.LOYAL_SCORE6 ,
T.LOYAL_SCORE7 =S.LOYAL_SCORE7 ,
T.MARGIN_VS_INDUST_NAME =S.MARGIN_VS_INDUST_NAME ,
T.MARGIN_VS_INDUST_CODE =S.MARGIN_VS_INDUST_CODE ,
T.MARKET_CLASS_NAME =S.MARKET_CLASS_NAME ,
T.MARKET_CLASS_CODE =S.MARKET_CLASS_CODE ,
T.MARKET_TYPE_NAME =S.MARKET_TYPE_NAME ,
T.MARKET_TYPE_CODE =S.MARKET_TYPE_CODE ,
T.MED_PROC =S.MED_PROC ,
T.MEMBER_NUM =S.MEMBER_NUM ,
T.MKT_POTENTIAL =S.MKT_POTENTIAL ,
T.MRKT_CAP_PREF_NAME =S.MRKT_CAP_PREF_NAME ,
T.MRKT_CAP_PREF_CODE =S.MRKT_CAP_PREF_CODE ,
T.NET_INCOME =S.NET_INCOME ,
T.NON_CASH_EXP =S.NON_CASH_EXP ,
T.NUMB_OF_BEDS =S.NUMB_OF_BEDS ,
T.OBJECTIVE_NAME =S.OBJECTIVE_NAME ,
T.OBJECTIVE_CODE =S.OBJECTIVE_CODE ,
T.OPER_INCOME =S.OPER_INCOME ,
T.PERSIST_RATIO =S.PERSIST_RATIO ,
T.PRIM_MARKET_NAME =S.PRIM_MARKET_NAME ,
T.PRIM_MARKET_CODE =S.PRIM_MARKET_CODE ,
T.PROJ_EPS =S.PROJ_EPS ,
T.PR_SPEC_NAME =S.PR_SPEC_NAME ,
T.PR_SYN_ID =S.PR_SYN_ID ,
T.QUICK_RATIO =S.QUICK_RATIO ,
T.SHARE_OUTST =S.SHARE_OUTST ,
T.SRV_PROVDR_FLG =S.SRV_PROVDR_FLG ,
T.STAT_REASON_NAME =S.STAT_REASON_NAME ,
T.STAT_REASON_CODE =S.STAT_REASON_CODE ,
T.TICKER =S.TICKER ,
T.TOTAL_DEBT =S.TOTAL_DEBT ,
T.TOTAL_NET_WORTH =S.TOTAL_NET_WORTH ,
T.TOT_ASSET =S.TOT_ASSET ,
T.TOT_LIABILITY =S.TOT_LIABILITY ,
T.TRAIL_EPS =S.TRAIL_EPS ,
T.U_EXCH_DT =S.U_EXCH_DT ,
T.U_LOYAL_SCORE5 =S.U_LOYAL_SCORE5 ,
T.VOLUME_TR =S.VOLUME_TR ,
T.SIC_CODE =S.SIC_CODE ,
T.SIC_NAME =S.SIC_NAME ,
T.GOVT_ID_TYPE =S.GOVT_ID_TYPE ,
T.GOVT_ID_VALUE =S.GOVT_ID_VALUE ,
T.DUNNS_SITE_NAME =S.DUNNS_SITE_NAME ,
T.DUNNS_GLOBAL_NAME =S.DUNNS_GLOBAL_NAME ,
T.DUNNS_LEGAL_NAME =S.DUNNS_LEGAL_NAME ,
T.CUSTOMER_NUM =S.CUSTOMER_NUM ,
T.ALT_CUSTOMER_NUM =S.ALT_CUSTOMER_NUM ,
T.ALT_PHONE_NUM =S.ALT_PHONE_NUM ,
T.INTERNET_HOME_PAGE =S.INTERNET_HOME_PAGE ,
T.LEGAL_STRUCT_NAME =S.LEGAL_STRUCT_NAME ,
T.LEGAL_STRUCT_CODE =S.LEGAL_STRUCT_CODE ,
T.DIRECT_MKTG_FLG =S.DIRECT_MKTG_FLG ,
T.SOLICITATION_FLG =S.SOLICITATION_FLG ,
T.VIS_PR_BU_ID =S.VIS_PR_BU_ID ,
T.VIS_PR_POS_ID =S.VIS_PR_POS_ID ,
T.VIS_PR_POSTN_DH_WID =S.VIS_PR_POSTN_DH_WID ,
T.SETID_CUSTOMER =S.SETID_CUSTOMER ,
T.SETID_VENDOR =S.SETID_VENDOR ,
T.SUPPLIER_ID =S.SUPPLIER_ID ,
T.PARENT_SUPPLIER_ID =S.PARENT_SUPPLIER_ID ,
T.SUPPLIER_NUM =S.SUPPLIER_NUM ,
T.SUPPLIER_GROUP_NAME =S.SUPPLIER_GROUP_NAME ,
T.SUPPLIER_GROUP_CODE =S.SUPPLIER_GROUP_CODE ,
T.SUPPLIER_CONTACT_NAME =S.SUPPLIER_CONTACT_NAME ,
T.SUPPLIER_TYPE_NAME =S.SUPPLIER_TYPE_NAME ,
T.SUPPLIER_TYPE_CODE =S.SUPPLIER_TYPE_CODE ,
T.MINORITY_GROUP_NAME =S.MINORITY_GROUP_NAME ,
T.MINORITY_GROUP_CODE =S.MINORITY_GROUP_CODE ,
T.SUPPLIER_SEARCH_STR =S.SUPPLIER_SEARCH_STR ,
T.PREF_ORDER_METHOD =S.PREF_ORDER_METHOD ,
T.SUPPLIER_EXT_NETWORK_ID =S.SUPPLIER_EXT_NETWORK_ID ,
T.SUPPLIER_ACTIVE_FLG =S.SUPPLIER_ACTIVE_FLG ,
T.SUPPLIER_ONE_TIME_FLG =S.SUPPLIER_ONE_TIME_FLG ,
T.OOB_IND =S.OOB_IND ,
T.MINORITY_OWNED_IND =S.MINORITY_OWNED_IND ,
T.WOMAN_OWNED_IND =S.WOMAN_OWNED_IND ,
T.SMALL_BUS_IND =S.SMALL_BUS_IND ,
T.YR_ESTABLISHED =S.YR_ESTABLISHED ,
T.DB_RATING =S.DB_RATING ,
T.INTERNAL_FLG =S.INTERNAL_FLG ,
T.FLEX_ATTRIB_1_CHAR =S.FLEX_ATTRIB_1_CHAR ,
T.FLEX_ATTRIB_2_CHAR =S.FLEX_ATTRIB_2_CHAR ,
T.FLEX_ATTRIB_3_CHAR =S.FLEX_ATTRIB_3_CHAR ,
T.FLEX_ATTRIB_4_CHAR =S.FLEX_ATTRIB_4_CHAR ,
T.FLEX_ATTRIB_5_CHAR =S.FLEX_ATTRIB_5_CHAR ,
T.FLEX_ATTRIB_6_CHAR =S.FLEX_ATTRIB_6_CHAR ,
T.FLEX_ATTRIB_7_CHAR =S.FLEX_ATTRIB_7_CHAR ,
T.FLEX_ATTRIB_8_CHAR =S.FLEX_ATTRIB_8_CHAR ,
T.FLEX_ATTRIB_9_CHAR =S.FLEX_ATTRIB_9_CHAR ,
T.FLEX_ATTRIB_10_CHAR =S.FLEX_ATTRIB_10_CHAR ,
T.FLEX_ATTRIB_11_CHAR =S.FLEX_ATTRIB_11_CHAR ,
T.FLEX_ATTRIB_12_CHAR =S.FLEX_ATTRIB_12_CHAR ,
T.FLEX_ATTRIB_13_CHAR =S.FLEX_ATTRIB_13_CHAR ,
T.FLEX_ATTRIB_14_CHAR =S.FLEX_ATTRIB_14_CHAR ,
T.FLEX_ATTRIB_15_CHAR =S.FLEX_ATTRIB_15_CHAR ,
T.FLEX_ATTRIB_16_CHAR =S.FLEX_ATTRIB_16_CHAR ,
T.FLEX_ATTRIB_17_CHAR =S.FLEX_ATTRIB_17_CHAR ,
T.FLEX_ATTRIB_18_CHAR =S.FLEX_ATTRIB_18_CHAR ,
T.FLEX_ATTRIB_19_CHAR =S.FLEX_ATTRIB_19_CHAR ,
T.FLEX_ATTRIB_20_CHAR =S.FLEX_ATTRIB_20_CHAR ,
T.CREATED_BY_WID =S.CREATED_BY_WID ,
T.CHANGED_BY_WID =S.CHANGED_BY_WID ,
T.CREATED_ON_DT =S.CREATED_ON_DT ,
T.CHANGED_ON_DT =S.CHANGED_ON_DT ,
T.AUX1_CHANGED_ON_DT =S.AUX1_CHANGED_ON_DT ,
T.AUX2_CHANGED_ON_DT =S.AUX2_CHANGED_ON_DT ,
T.AUX3_CHANGED_ON_DT =S.AUX3_CHANGED_ON_DT ,
T.AUX4_CHANGED_ON_DT =S.AUX4_CHANGED_ON_DT ,
T.SRC_EFF_FROM_DT =S.SRC_EFF_FROM_DT ,
T.SRC_EFF_TO_DT =S.SRC_EFF_TO_DT ,
T.EFFECTIVE_FROM_DT =S.EFFECTIVE_FROM_DT ,
T.EFFECTIVE_TO_DT =S.EFFECTIVE_TO_DT ,
T.DELETE_FLG =S.DELETE_FLG ,
T.CURRENT_FLG =S.CURRENT_FLG ,
T.W_UPDATE_DT =S.W_UPDATE_DT ,
T.ETL_PROC_WID =S.ETL_PROC_WID ,
T.TENANT_ID =S.TENANT_ID ,
T.X_CUSTOM =S.X_CUSTOM ,
T.ACCNT_REGION =S.ACCNT_REGION ,
T.X_COMPANY_REG_NUM =S.X_COMPANY_REG_NUM WHEN NOT MATCHED THEN
INSERT
(
T.ROW_WID ,
T.GEO_WID ,
T.ACCNT_GEOSTATE_WID ,
T.ORG_NAME ,
T.MAIN_PH_NUM ,
T.ST_ADDRESS1 ,
T.ST_ADDRESS2 ,
T.ST_ADDRESS3 ,
T.ST_ADDRESS4 ,
T.POSTAL_CODE ,
T.CITY_NAME ,
T.CITY_CODE ,
T.STATE_NAME ,
T.STATE_CODE ,
T.COUNTRY_NAME ,
T.COUNTRY_CODE ,
T.REGION_NAME ,
T.REGION_CODE ,
T.ACTIVE_FLG ,
T.PROSPECT_FLG ,
T.SUPPLIER_FLG ,
T.COMPETITOR_FLG ,
T.ACCNT_FLG ,
T.ACCNT_LOC ,
T.CUST_STATUS_NAME ,
T.CUST_STATUS_CODE ,
T.CUST_TYPE_NAME ,
T.CUST_TYPE_CODE ,
T.CUST_CAT_NAME ,
T.CUST_CAT_CODE ,
T.ANNUAL_REVN_CAT_NAME ,
T.ANNUAL_REVN_CAT_CODE ,
T.BASE_CURCY_CD ,
T.BU_NAME ,
T.CHANNEL_FLG ,
T.CHNL_ANNL_SALES ,
T.CHNL_SALES_GRWTH_NAME ,
T.CHNL_SALES_GRWTH_CODE ,
T.DIVN_FLG ,
T.DIVN_TYPE_NAME ,
T.DIVN_TYPE_CODE ,
T.DOM_ULT_DUNS_NUM ,
T.DUNS_NUM ,
T.EMP_COUNT ,
T.EXPERTISE_NAME ,
T.EXPERTISE_CODE ,
T.FORMED_DT ,
T.FRGHT_TERMS_NAME ,
T.FRGHT_TERMS_CODE ,
T.GLBLULT_DUNS_NUM ,
T.HIST_SLS_VOL ,
T.LINE_OF_BUSINESS ,
T.NUM_EMPLOY_CAT_NAME ,
T.NUM_EMPLOY_CAT_CODE ,
T.ORG_TERR_NAME ,
T.ORG_FLG ,
T.ORG_PRTNR_FLG ,
T.ORG_PRTNR_TIER_NAME ,
T.ORG_PRTNR_TIER_CODE ,
T.ORG_PRTNR_TYPE_NAME ,
T.ORG_PRTNR_TYPE_CODE ,
T.PAR_DUNS_NUM ,
T.PAR_INTEGRATION_ID ,
T.PAR_ORG_NAME ,
T.PRI_LST_NAME ,
T.PRTNRSHP_START_DT ,
T.PRTNR_FLG ,
T.PRTNR_NAME ,
T.PRTNR_SALES_RANK ,
T.PR_COMPETITOR ,
T.PR_INDUST_NAME ,
T.PR_ORG_TRGT_MKT ,
T.PR_PTSHP_MKTSEG ,
T.PTNTL_SLS_VOL ,
T.PTSHP_END_DT ,
T.PTSHP_FEE_PAID_FLG ,
T.PTSHP_PRTNR_ACCNT ,
T.PTSHP_RENEWAL_DT ,
T.PTSHP_SAT_INDEX ,
T.PTSHP_STAGE_NAME ,
T.PTSHP_STAGE_CODE ,
T.PUBLIC_LISTING_FLG ,
T.REVN_GROWTH_CAT_NAME ,
T.REVN_GROWTH_CAT_CODE ,
T.SALES_EMP_CNT ,
T.SERVICE_EMP_CNT ,
T.ACCNT_AHA_NUM ,
T.ACCNT_HIN_NUM ,
T.CUST_CLASS_NAME ,
T.CUST_CLASS_CODE ,
T.CUST_VALUE_NAME ,
T.CUST_VALUE_CODE ,
T.AGENCY_FLG ,
T.AGNC_CONTRACT_DT ,
T.ANNUAL_REVENUE ,
T.BOOK_VALUE ,
T.BRANCH_FLG ,
T.CALL_FREQUENCY ,
T.CLIENT_FLG ,
T.CREDIT_SCORE ,
T.CRIME_TYPE_NAME ,
T.CRIME_TYPE_CODE ,
T.CURR_ASSET ,
T.CURR_LIAB ,
T.CUST_END_DT ,
T.CUST_SINCE_DT ,
T.DIVIDEND ,
T.EXCHANGE_LOC ,
T.FACILITY_FLG ,
T.FACILITY_TYPE_NAME ,
T.FACILITY_TYPE_CODE ,
T.FIFTYTWO_HIGH ,
T.FIFTYTWO_LOW ,
T.FIN_METHOD_NAME ,
T.FIN_METHOD_CODE ,
T.GROSS_PROFIT ,
T.GROWTH_HORIZ_NAME ,
T.GROWTH_HORIZ_CODE ,
T.GROWTH_OBJ_NAME ,
T.GROWTH_OBJ_CODE ,
T.GROWTH_PERCNTG ,
T.IDENTIFIED_DT ,
T.INVESTOR_FLG ,
T.KEY_COMPETITOR ,
T.LEGAL_FORM_NAME ,
T.LEGAL_FORM_CODE ,
T.LOYAL_SCORE1 ,
T.LOYAL_SCORE2 ,
T.LOYAL_SCORE3 ,
T.LOYAL_SCORE4 ,
T.LOYAL_SCORE5 ,
T.LOYAL_SCORE6 ,
T.LOYAL_SCORE7 ,
T.MARGIN_VS_INDUST_NAME ,
T.MARGIN_VS_INDUST_CODE ,
T.MARKET_CLASS_NAME ,
T.MARKET_CLASS_CODE ,
T.MARKET_TYPE_NAME ,
T.MARKET_TYPE_CODE ,
T.MED_PROC ,
T.MEMBER_NUM ,
T.MKT_POTENTIAL ,
T.MRKT_CAP_PREF_NAME ,
T.MRKT_CAP_PREF_CODE ,
T.NET_INCOME ,
T.NON_CASH_EXP ,
T.NUMB_OF_BEDS ,
T.OBJECTIVE_NAME ,
T.OBJECTIVE_CODE ,
T.OPER_INCOME ,
T.PERSIST_RATIO ,
T.PRIM_MARKET_NAME ,
T.PRIM_MARKET_CODE ,
T.PROJ_EPS ,
T.PR_SPEC_NAME ,
T.PR_SYN_ID ,
T.QUICK_RATIO ,
T.SHARE_OUTST ,
T.SRV_PROVDR_FLG ,
T.STAT_REASON_NAME ,
T.STAT_REASON_CODE ,
T.TICKER ,
T.TOTAL_DEBT ,
T.TOTAL_NET_WORTH ,
T.TOT_ASSET ,
T.TOT_LIABILITY ,
T.TRAIL_EPS ,
T.U_EXCH_DT ,
T.U_LOYAL_SCORE5 ,
T.VOLUME_TR ,
T.SIC_CODE ,
T.SIC_NAME ,
T.GOVT_ID_TYPE ,
T.GOVT_ID_VALUE ,
T.DUNNS_SITE_NAME ,
T.DUNNS_GLOBAL_NAME ,
T.DUNNS_LEGAL_NAME ,
T.CUSTOMER_NUM ,
T.ALT_CUSTOMER_NUM ,
T.ALT_PHONE_NUM ,
T.INTERNET_HOME_PAGE ,
T.LEGAL_STRUCT_NAME ,
T.LEGAL_STRUCT_CODE ,
T.DIRECT_MKTG_FLG ,
T.SOLICITATION_FLG ,
T.VIS_PR_BU_ID ,
T.VIS_PR_POS_ID ,
T.VIS_PR_POSTN_DH_WID ,
T.SETID_CUSTOMER ,
T.SETID_VENDOR ,
T.SUPPLIER_ID ,
T.PARENT_SUPPLIER_ID ,
T.SUPPLIER_NUM ,
T.SUPPLIER_GROUP_NAME ,
T.SUPPLIER_GROUP_CODE ,
T.SUPPLIER_CONTACT_NAME ,
T.SUPPLIER_TYPE_NAME ,
T.SUPPLIER_TYPE_CODE ,
T.MINORITY_GROUP_NAME ,
T.MINORITY_GROUP_CODE ,
T.SUPPLIER_SEARCH_STR ,
T.PREF_ORDER_METHOD ,
T.SUPPLIER_EXT_NETWORK_ID ,
T.SUPPLIER_ACTIVE_FLG ,
T.SUPPLIER_ONE_TIME_FLG ,
T.OOB_IND ,
T.MINORITY_OWNED_IND ,
T.WOMAN_OWNED_IND ,
T.SMALL_BUS_IND ,
T.YR_ESTABLISHED ,
T.DB_RATING ,
T.INTERNAL_FLG ,
T.FLEX_ATTRIB_1_CHAR ,
T.FLEX_ATTRIB_2_CHAR ,
T.FLEX_ATTRIB_3_CHAR ,
T.FLEX_ATTRIB_4_CHAR ,
T.FLEX_ATTRIB_5_CHAR ,
T.FLEX_ATTRIB_6_CHAR ,
T.FLEX_ATTRIB_7_CHAR ,
T.FLEX_ATTRIB_8_CHAR ,
T.FLEX_ATTRIB_9_CHAR ,
T.FLEX_ATTRIB_10_CHAR ,
T.FLEX_ATTRIB_11_CHAR ,
T.FLEX_ATTRIB_12_CHAR ,
T.FLEX_ATTRIB_13_CHAR ,
T.FLEX_ATTRIB_14_CHAR ,
T.FLEX_ATTRIB_15_CHAR ,
T.FLEX_ATTRIB_16_CHAR ,
T.FLEX_ATTRIB_17_CHAR ,
T.FLEX_ATTRIB_18_CHAR ,
T.FLEX_ATTRIB_19_CHAR ,
T.FLEX_ATTRIB_20_CHAR ,
T.CREATED_BY_WID ,
T.CHANGED_BY_WID ,
T.CREATED_ON_DT ,
T.CHANGED_ON_DT ,
T.AUX1_CHANGED_ON_DT ,
T.AUX2_CHANGED_ON_DT ,
T.AUX3_CHANGED_ON_DT ,
T.AUX4_CHANGED_ON_DT ,
T.SRC_EFF_FROM_DT ,
T.SRC_EFF_TO_DT ,
T.EFFECTIVE_FROM_DT ,
T.EFFECTIVE_TO_DT ,
T.DELETE_FLG ,
T.CURRENT_FLG ,
T.W_INSERT_DT ,
T.W_UPDATE_DT ,
T.DATASOURCE_NUM_ID ,
T.ETL_PROC_WID ,
T.INTEGRATION_ID ,
T.TENANT_ID ,
T.X_CUSTOM ,
T.ACCNT_REGION ,
T.X_COMPANY_REG_NUM
)
VALUES
(
S.ROW_WID ,
S.GEO_WID ,
S.ACCNT_GEOSTATE_WID ,
S.ORG_NAME ,
S.MAIN_PH_NUM ,
S.ST_ADDRESS1 ,
S.ST_ADDRESS2 ,
S.ST_ADDRESS3 ,
S.ST_ADDRESS4 ,
S.POSTAL_CODE ,
S.CITY_NAME ,
S.CITY_CODE ,
S.STATE_NAME ,
S.STATE_CODE ,
S.COUNTRY_NAME ,
S.COUNTRY_CODE ,
S.REGION_NAME ,
S.REGION_CODE ,
S.ACTIVE_FLG ,
S.PROSPECT_FLG ,
S.SUPPLIER_FLG ,
S.COMPETITOR_FLG ,
S.ACCNT_FLG ,
S.ACCNT_LOC ,
S.CUST_STATUS_NAME ,
S.CUST_STATUS_CODE ,
S.CUST_TYPE_NAME ,
S.CUST_TYPE_CODE ,
S.CUST_CAT_NAME ,
S.CUST_CAT_CODE ,
S.ANNUAL_REVN_CAT_NAME ,
S.ANNUAL_REVN_CAT_CODE ,
S.BASE_CURCY_CD ,
S.BU_NAME ,
S.CHANNEL_FLG ,
S.CHNL_ANNL_SALES ,
S.CHNL_SALES_GRWTH_NAME ,
S.CHNL_SALES_GRWTH_CODE ,
S.DIVN_FLG ,
S.DIVN_TYPE_NAME ,
S.DIVN_TYPE_CODE ,
S.DOM_ULT_DUNS_NUM ,
S.DUNS_NUM ,
S.EMP_COUNT ,
S.EXPERTISE_NAME ,
S.EXPERTISE_CODE ,
S.FORMED_DT ,
S.FRGHT_TERMS_NAME ,
S.FRGHT_TERMS_CODE ,
S.GLBLULT_DUNS_NUM ,
S.HIST_SLS_VOL ,
S.LINE_OF_BUSINESS ,
S.NUM_EMPLOY_CAT_NAME ,
S.NUM_EMPLOY_CAT_CODE ,
S.ORG_TERR_NAME ,
S.ORG_FLG ,
S.ORG_PRTNR_FLG ,
S.ORG_PRTNR_TIER_NAME ,
S.ORG_PRTNR_TIER_CODE ,
S.ORG_PRTNR_TYPE_NAME ,
S.ORG_PRTNR_TYPE_CODE ,
S.PAR_DUNS_NUM ,
S.PAR_INTEGRATION_ID ,
S.PAR_ORG_NAME ,
S.PRI_LST_NAME ,
S.PRTNRSHP_START_DT ,
S.PRTNR_FLG ,
S.PRTNR_NAME ,
S.PRTNR_SALES_RANK ,
S.PR_COMPETITOR ,
S.PR_INDUST_NAME ,
S.PR_ORG_TRGT_MKT ,
S.PR_PTSHP_MKTSEG ,
S.PTNTL_SLS_VOL ,
S.PTSHP_END_DT ,
S.PTSHP_FEE_PAID_FLG ,
S.PTSHP_PRTNR_ACCNT ,
S.PTSHP_RENEWAL_DT ,
S.PTSHP_SAT_INDEX ,
S.PTSHP_STAGE_NAME ,
S.PTSHP_STAGE_CODE ,
S.PUBLIC_LISTING_FLG ,
S.REVN_GROWTH_CAT_NAME ,
S.REVN_GROWTH_CAT_CODE ,
S.SALES_EMP_CNT ,
S.SERVICE_EMP_CNT ,
S.ACCNT_AHA_NUM ,
S.ACCNT_HIN_NUM ,
S.CUST_CLASS_NAME ,
S.CUST_CLASS_CODE ,
S.CUST_VALUE_NAME ,
S.CUST_VALUE_CODE ,
S.AGENCY_FLG ,
S.AGNC_CONTRACT_DT ,
S.ANNUAL_REVENUE ,
S.BOOK_VALUE ,
S.BRANCH_FLG ,
S.CALL_FREQUENCY ,
S.CLIENT_FLG ,
S.CREDIT_SCORE ,
S.CRIME_TYPE_NAME ,
S.CRIME_TYPE_CODE ,
S.CURR_ASSET ,
S.CURR_LIAB ,
S.CUST_END_DT ,
S.CUST_SINCE_DT ,
S.DIVIDEND ,
S.EXCHANGE_LOC ,
S.FACILITY_FLG ,
S.FACILITY_TYPE_NAME ,
S.FACILITY_TYPE_CODE ,
S.FIFTYTWO_HIGH ,
S.FIFTYTWO_LOW ,
S.FIN_METHOD_NAME ,
S.FIN_METHOD_CODE ,
S.GROSS_PROFIT ,
S.GROWTH_HORIZ_NAME ,
S.GROWTH_HORIZ_CODE ,
S.GROWTH_OBJ_NAME ,
S.GROWTH_OBJ_CODE ,
S.GROWTH_PERCNTG ,
S.IDENTIFIED_DT ,
S.INVESTOR_FLG ,
S.KEY_COMPETITOR ,
S.LEGAL_FORM_NAME ,
S.LEGAL_FORM_CODE ,
S.LOYAL_SCORE1 ,
S.LOYAL_SCORE2 ,
S.LOYAL_SCORE3 ,
S.LOYAL_SCORE4 ,
S.LOYAL_SCORE5 ,
S.LOYAL_SCORE6 ,
S.LOYAL_SCORE7 ,
S.MARGIN_VS_INDUST_NAME ,
S.MARGIN_VS_INDUST_CODE ,
S.MARKET_CLASS_NAME ,
S.MARKET_CLASS_CODE ,
S.MARKET_TYPE_NAME ,
S.MARKET_TYPE_CODE ,
S.MED_PROC ,
S.MEMBER_NUM ,
S.MKT_POTENTIAL ,
S.MRKT_CAP_PREF_NAME ,
S.MRKT_CAP_PREF_CODE ,
S.NET_INCOME ,
S.NON_CASH_EXP ,
S.NUMB_OF_BEDS ,
S.OBJECTIVE_NAME ,
S.OBJECTIVE_CODE ,
S.OPER_INCOME ,
S.PERSIST_RATIO ,
S.PRIM_MARKET_NAME ,
S.PRIM_MARKET_CODE ,
S.PROJ_EPS ,
S.PR_SPEC_NAME ,
S.PR_SYN_ID ,
S.QUICK_RATIO ,
S.SHARE_OUTST ,
S.SRV_PROVDR_FLG ,
S.STAT_REASON_NAME ,
S.STAT_REASON_CODE ,
S.TICKER ,
S.TOTAL_DEBT ,
S.TOTAL_NET_WORTH ,
S.TOT_ASSET ,
S.TOT_LIABILITY ,
S.TRAIL_EPS ,
S.U_EXCH_DT ,
S.U_LOYAL_SCORE5 ,
S.VOLUME_TR ,
S.SIC_CODE ,
S.SIC_NAME ,
S.GOVT_ID_TYPE ,
S.GOVT_ID_VALUE ,
S.DUNNS_SITE_NAME ,
S.DUNNS_GLOBAL_NAME ,
S.DUNNS_LEGAL_NAME ,
S.CUSTOMER_NUM ,
S.ALT_CUSTOMER_NUM ,
S.ALT_PHONE_NUM ,
S.INTERNET_HOME_PAGE ,
S.LEGAL_STRUCT_NAME ,
S.LEGAL_STRUCT_CODE ,
S.DIRECT_MKTG_FLG ,
S.SOLICITATION_FLG ,
S.VIS_PR_BU_ID ,
S.VIS_PR_POS_ID ,
S.VIS_PR_POSTN_DH_WID ,
S.SETID_CUSTOMER ,
S.SETID_VENDOR ,
S.SUPPLIER_ID ,
S.PARENT_SUPPLIER_ID ,
S.SUPPLIER_NUM ,
S.SUPPLIER_GROUP_NAME ,
S.SUPPLIER_GROUP_CODE ,
S.SUPPLIER_CONTACT_NAME ,
S.SUPPLIER_TYPE_NAME ,
S.SUPPLIER_TYPE_CODE ,
S.MINORITY_GROUP_NAME ,
S.MINORITY_GROUP_CODE ,
S.SUPPLIER_SEARCH_STR ,
S.PREF_ORDER_METHOD ,
S.SUPPLIER_EXT_NETWORK_ID ,
S.SUPPLIER_ACTIVE_FLG ,
S.SUPPLIER_ONE_TIME_FLG ,
S.OOB_IND ,
S.MINORITY_OWNED_IND ,
S.WOMAN_OWNED_IND ,
S.SMALL_BUS_IND ,
S.YR_ESTABLISHED ,
S.DB_RATING ,
S.INTERNAL_FLG ,
S.FLEX_ATTRIB_1_CHAR ,
S.FLEX_ATTRIB_2_CHAR ,
S.FLEX_ATTRIB_3_CHAR ,
S.FLEX_ATTRIB_4_CHAR ,
S.FLEX_ATTRIB_5_CHAR ,
S.FLEX_ATTRIB_6_CHAR ,
S.FLEX_ATTRIB_7_CHAR ,
S.FLEX_ATTRIB_8_CHAR ,
S.FLEX_ATTRIB_9_CHAR ,
S.FLEX_ATTRIB_10_CHAR ,
S.FLEX_ATTRIB_11_CHAR ,
S.FLEX_ATTRIB_12_CHAR ,
S.FLEX_ATTRIB_13_CHAR ,
S.FLEX_ATTRIB_14_CHAR ,
S.FLEX_ATTRIB_15_CHAR ,
S.FLEX_ATTRIB_16_CHAR ,
S.FLEX_ATTRIB_17_CHAR ,
S.FLEX_ATTRIB_18_CHAR ,
S.FLEX_ATTRIB_19_CHAR ,
S.FLEX_ATTRIB_20_CHAR ,
S.CREATED_BY_WID ,
S.CHANGED_BY_WID ,
S.CREATED_ON_DT ,
S.CHANGED_ON_DT ,
S.AUX1_CHANGED_ON_DT ,
S.AUX2_CHANGED_ON_DT ,
S.AUX3_CHANGED_ON_DT ,
S.AUX4_CHANGED_ON_DT ,
S.SRC_EFF_FROM_DT ,
S.SRC_EFF_TO_DT ,
S.EFFECTIVE_FROM_DT ,
S.EFFECTIVE_TO_DT ,
S.DELETE_FLG ,
S.CURRENT_FLG ,
S.W_INSERT_DT ,
S.W_UPDATE_DT ,
S.DATASOURCE_NUM_ID ,
S.ETL_PROC_WID ,
S.INTEGRATION_ID ,
S.TENANT_ID ,
S.X_CUSTOM ,
S.ACCNT_REGION ,
S.X_COMPANY_REG_NUM
);
commit;
4. Once done, execute the entire worksheet by clicking on the RunScript
button or F5 key. 5. When all the three queries (Delete, Index creation and Merge) are successfully executed, open DAC and login to the Prod environment.
6. In Execute section, open the current runs tab in the top pane and Tasks in the bottom pane.
7. In the bottom pane, select failed from the dropdown instead of all.
8. When selected, the failed SIL_PartyOrganizationDimension task will be shown. In that, under Task Status click on the text failed. It will open as a drop down, set it to Completed. Then click save button in the bottom pane as shown in the screenshot below.
9. Then if the load is still running, leave it as such as the load will continue. Else if the entire load is failed (ie., in the current runs tab, the load will have the Run Status as Failed), Click on the Restart button.
10. Once clicked, the load will continue from the next task to run.
Note: This procedure applies to any task failure irrespective of the loads except for the steps involving execution of the post SQL in Data Warehouse.
Comments
Post a Comment