customization of dff in informatica2
TRANSCRIPT
CUSTOMIZATION OF DFF – Values for OBIA
Repository Used :
XYLBIWD_091113.rpd copy of XYLBIWD_08212013_Migration_BI0001.rpd.
Task 1: DFF – Supplier Cost from PO_LINES_ALL table ie. Attribute7. Here Attribute7 from PO_LINES_ALL table will store Supplier Item Cost and It will be part of Procurement and Spend – Purchase Order in OBIA Repository. Attribute7 should be part of Purchase Details.
See highlighted .. One of the Mapping is a problem – SDE_ORA_PurchaseCostFact is failing but SDE_ORA_PurchaseOrderFact is good enough to populate the required information. Retain One of the Changes and Ignore PurchaseCostFact Mapping.
Physical Layer - > Oracle Data Warehouse -> Catalog -> dbo -> W_PURCHASE_COST_F, W_PURCHASE_ORDER_F
BMM Layer -> Dim-Purchase Order Attributes -> Attibute Columns ( PO Lines – Supplier Cost, PO Lines Attribute7)
Presentation Layer - > Procurement and Spend – Purchase Orders -> Purchase Details -> PO Lines Supplier Cost, Attribute7
Designer Changes
INFORMATICA Changes: Designer
EXTRACT:
SDE_ORAR1213_Adapter_Custom
Mapping:
SCE_ORA_PurchaseOrderFact SCE_ORA_PurchaseCostFact
Target :
W_PURCH_ORDER_FS W_PURCH_COST_FS_TMP
LOAD:
Mapping:
SILOS_ORAR1213_Adapter_Custom
SIL_PurchaseOrderFact
Source: W_PURCH_ORDER_FS
Target: W_PURCH_ORDER_F
SIL_PurchaseCostFact
Source: W_PURCH_COST_FS
Target: W_PURCH_COST_F
Workflow Manager Changes
SDE_ORA_PurchaseOrderFact SDE_ORA_PurchaseOrderFact_Full SDE_ORA_PurchaseCostFact SDE_ORA_PurchaseCostFact_Full
NOTE: Changes not made in SDE_ORA_PurchaseCostFact_AgreementMatchSDE_ORA_PurchaseOrderFact_Primary
Workflow Monitor:
SCE_ORA_PURCHASEORDERFACT_FULL
Task 2: Supplier Attributes - Attribute 3 and Attribute4 from PO_VENDOR_SITES_ALL where Attribute3 Captures International Flag – Yes_No Value and Attribute4 captures Domestic Flag – Yes_No value. This needs to be populated with all Supplier Details in the Presentation Layer.
Mapping: SDE_ORAR1213_Adapter_Custom
Extract:
Mapping: SDE_ORA_SupplierAccountDimension
Target : W_SUPPLIER_ACCOUNT_DS
Load :
Mapping : SILOS_ORAR1213_Adapter_Custom
SIL_SupplierAccountDimension
SIL_SupplierAccountDimension_SCDUpdate
SIL_SupplierAccountDimension_Unspecified
Source:
W_SUPPLIER_ACCOUNT_DS
Target : W_SUPPLIER_ACCOUNT_D
Workflow Designer:
SDE_ORA_SupplierAccountDimension
SDE_ORA_SupplierAccountDimension_Full
SIL_SupplierAccountDimension
SIL_SupplierAccountDimension_Full
SIL_SupplierAccountDimension_SCDUpdate
SIL_SupplierAccountDimension_SCDUpdate_Full
Workflow Monitor:
Repository Changes Applied ON:
Physical Layer:
Oracle Data Warehouse -> Catalog -> dbo -> W_SUPPLIER_ACCOUNT_D
BMM Layer ::
Core -> Dim – Supplier Account
Presentation Layer::
Procurement_and_Spend- Purchase Orders -> Supplier Account -> AttributeColumns
Procurement and Spend – Invoice Lines -> Supplier Account -> AttributeCOlumns
Procurement and Spend – Procure to Pay -> Supplier Account -> AttributeColumns
Procurement and Spend – Purchase Receipt -> Supplier Account -> AttributeColumns
Procurement and Spend – Purchase Requisitions -> Supplier Account -> AttributeColumns
Financials - AP Balance -> Supplier Account -> AttributeColumns
Financials – AP Invoice Aging -> Supplier Account -> AttributeColumns
Financials – AP Overview -> Supplier Account -> AttributeColumns
Financials – AP Transactions -> Supplier Account -> AttributeColumns
Task3: Customization of Customer Party Sites Attributes. Included Fields – Attribute2 and Attribute3 from HZ_PARTY_SITES table. Attribute2 holds International Customer Yes/No , Attribute3 Holds Domestic Customer Yes/No Values.
SDE_ORAR1213_Adapter_Custom
Mapping : SDE_ORA_CustomerLocationDimension
Target : W_CUSTOMER_LOC_DS
SILOS_ORAR1213_Adapter_Custom
Mapping : SIL_CustomerLocationDimension
Source: W_CUSTOMER_LOC_DS
Target : W_CUSTOMER_LOC_D
Mapping : SIL_CustomerLocationDimension_SCDUpdate
Source: W_CUSTOMER_LOC_D
Target : W_CUSTOMER_LOC_D1
Mapping : SIL_CustomerLocationDimension_Unspecified
Target : W_CUSTOMER_LOC_D
Workflow Manager:
SDE_ORA_CustomerLocationDimension1
SDE_ORA_CustomerLocationDimension_Full
SIL_CustomerLocationDimension1
SIL_CustomerLocationDimension_Full1
SIL_CustomerLocationDimension_SCDUpdate1
SIL_CustomerLocationDimension_SCDUpdate_Full
Workflow Monitor:
Physical Layer:
Oracle Data Warehouse -> Catalog -> dbo -> W_CUSTOMER_LOC_D
BMM Layer ::
Core -> Dim – Customer Bill To Location – Attribute Columns ( International, Domestic)
Presentation Layer::
Financials – AR Invoice Aging - > Customer Bill To Location -> Attribute Columns ( International, Domestic)
Financials – AR Transactions - > Customer Bill To Location -> Attribute Columns ( International, Domestic)
Other Extra Changes :: Adding Supplier Site Code under AP Subject Area in Repository
Presentation Layer - > Financials AP Balances - > Supplier Account -> Supplier Account Site Code
Financials AP Invoice Aging - > Supplier Account -> Supplier Account Site Code
Financials AP Overview - > Supplier Account -> Supplier Account Site Code
Financials AP Transactions - > Supplier Account -> Supplier Account Site Code
Procurement and Spend - Invoice Lines - > Supplier Account -> Supplier Account Site Code
Procurement and Spend -Procure to Pay - > Supplier Account -> Supplier Account Site Code
Procurement and Spend - Purchase Orders - > Supplier Account -> Supplier Account Site Code
Procurement and Spend - Purchase requisitions - > Supplier Account -> Supplier Account Site Code