""" uuid: c05767f6-dd2f-4eaa-afdc-0695173a8194\n langcode: en\n status: true\n dependencies:\n enforced:\n module:\n - dp_import\n _core:\n default_config_hash: RGaDo0sqjGEozx_LTMO8glCq3Xz4MljcPAT4vw1L7Do\n id: dp_static\n class: null\n field_plugin_method: null\n cck_plugin_method: null\n migration_tags: DP\n migration_group: dp_import\n label: 'DP static data import'\n source:\n plugin: csv\n path: /var/www/html/private/derivativepartners/dp_staticdata_new_UTF8.csv\n delimiter: ;\n enclosure: '"'\n header_offset: 0\n ids:\n - Product_ID\n - Underlying_Product_ID\n track_changes: true\n process:\n product_attribute_name:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Attribute_Name\n product_class1_name_d:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Class1_Name_D\n product_class1_name_e:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Class1_Name_E\n product_class2_name_d:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Class2_Name_D\n product_class2_name_e:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Class2_Name_E\n product_class2_official_svsp_id:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Class2_Official_SVSP_ID\n product_class2_official_svsp_id_new:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Class2_Official_SVSP_ID_NEW\n product_class2_strike1_alias:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Class2_Strike1_Alias\n product_class2_strike2_alias:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Class2_Strike2_Alias\n product_class2_strike3_alias:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Class2_Strike3_Alias\n product_class2_strike4_alias:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Class2_Strike4_Alias\n product_coupon:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Coupon\n product_coupon_interest:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Coupon_Interest\n product_coupon_premium:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Coupon_Premium\n product_currency_tradingbased_short:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Currency_TradingBased_Short\n product_currency_trading_short:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Currency_Trading_Short\n product_earliestexercisedate:\n -\n plugin: format_date\n from_format: 'Y-m-d H:i:s'\n to_format: U\n source: Product_EarliestExerciseDate\n -\n plugin: static_map\n map:\n '': null\n bypass: true\n product_exchange_name:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Exchange_Name\n product_exercise_entitlestounit:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Exercise_EntitlesToUnit\n product_exercise_numberneeded:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Exercise_NumberNeeded\n product_factor:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Factor\n product_feature_1_id:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Feature_1_ID\n product_feature_2_id:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Feature_2_ID\n product_feature_3_id:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Feature_3_ID\n product_feature_4_id:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Feature_4_ID\n product_feature_5_id:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Feature_5_ID\n product_feature_availability:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Feature_Availability\n product_firstlistingdate:\n -\n plugin: format_date\n from_format: 'Y-m-d H:i:s'\n to_format: U\n source: Product_FirstlistingDate\n -\n plugin: static_map\n map:\n '': null\n bypass: true\n product_id:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_ID\n product_isin:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_ISIN\n product_isactivemanaged:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_IsActiveManaged\n product_iscleanpriced:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_IsCleanPriced\n product_iscollateralized:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_IsCollateralized\n product_ispercentage:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_IsPercentage\n product_isquanto:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_IsQuanto\n product_issueprice:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_IssuePrice\n product_issuer_name:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Issuer_Name\n product_issuer_short:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Issuer_Short\n product_lasttradingdate:\n -\n plugin: format_date\n from_format: 'Y-m-d H:i:s'\n to_format: U\n source: Product_LastTradingDate\n -\n plugin: static_map\n map:\n '': null\n bypass: true\n product_management_fees:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Management_Fees\n product_maturitydate:\n -\n plugin: format_date\n from_format: 'Y-m-d H:i:s'\n to_format: U\n source: Product_MaturityDate\n -\n plugin: static_map\n map:\n '': null\n bypass: true\n product_name_e:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Name_E\n product_nominalvalue:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_NominalValue\n product_participation_level:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Participation_Level\n product_payment_winscale_downside:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Payment_WinScale_Downside\n product_protection_level_percent:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Protection_Level_Percent\n product_ratio:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Ratio\n product_status:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Status\n product_style_short:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Style_Short\n product_subscription_enddate:\n -\n plugin: format_date\n from_format: 'Y-m-d H:i:s'\n to_format: U\n source: Product_Subscription_EndDate\n -\n plugin: static_map\n map:\n '': null\n bypass: true\n product_symbol:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Symbol\n product_termsheet:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_Termsheet\n product_wkn:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Product_WKN\n underlying_assetclass_name:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_AssetClass_Name\n underlying_component_country_name:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Country_Name\n underlying_component_icb_sector_offical_id:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_ICB_Sector_Offical_ID\n underlying_component_isin:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_ISIN\n underlying_component_initial_fixing_currency_short:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Initial_Fixing_Currency_Short\n underlying_component_initial_fixing_price:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Initial_Fixing_Price\n underlying_component_name:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Name\n underlying_component_strike_1_currency_short:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_1_Currency_Short\n underlying_component_strike_1_percent:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_1_Percent\n underlying_component_strike_1_price:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_1_Price\n underlying_component_strike_2_currency_short:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_2_Currency_Short\n underlying_component_strike_2_percent:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_2_Percent\n underlying_component_strike_2_price:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_2_Price\n underlying_component_strike_3_currency_short:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_3_Currency_Short\n underlying_component_strike_3_percent:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_3_Percent\n underlying_component_strike_3_price:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_3_Price\n underlying_component_strike_4_currency_short:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_4_Currency_Short\n underlying_component_strike_4_percent:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_4_Percent\n underlying_component_strike_4_price:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Strike_4_Price\n underlying_component_symbol:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Symbol\n underlying_component_weight:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Component_Weight\n underlying_compositiontype_name:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_CompositionType_Name\n underlying_description:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Description\n underlying_id:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_ID\n underlying_isin:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_ISIN\n underlying_initial_fixing_date:\n -\n plugin: format_date\n from_format: 'Y-m-d H:i:s'\n to_format: U\n source: Underlying_Initial_Fixing_Date\n -\n plugin: static_map\n map:\n '': null\n bypass: true\n underlying_name:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Name\n underlying_product_id:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Product_ID\n underlying_symbol:\n plugin: static_map\n map:\n '': null\n bypass: true\n source: Underlying_Symbol\n destination:\n plugin: table\n table_name: dp_static\n batch_size: 1000\n id_fields:\n product_id:\n type: integer\n underlying_product_id:\n type: integer\n fields:\n product_attribute_name: product_attribute_name\n product_class1_name_d: product_class1_name_d\n product_class1_name_e: product_class1_name_e\n product_class2_name_d: product_class2_name_d\n product_class2_name_e: product_class2_name_e\n product_class2_official_svsp_id: product_class2_official_svsp_id\n product_class2_official_svsp_id_new: product_class2_official_svsp_id_new\n product_class2_strike1_alias: product_class2_strike1_alias\n product_class2_strike2_alias: product_class2_strike2_alias\n product_class2_strike3_alias: product_class2_strike3_alias\n product_class2_strike4_alias: product_class2_strike4_alias\n product_coupon: product_coupon\n product_coupon_interest: product_coupon_interest\n product_coupon_premium: product_coupon_premium\n product_currency_tradingbased_short: product_currency_tradingbased_short\n product_currency_trading_short: product_currency_trading_short\n product_earliestexercisedate: product_earliestexercisedate\n product_exchange_name: product_exchange_name\n product_exercise_entitlestounit: product_exercise_entitlestounit\n product_exercise_numberneeded: product_exercise_numberneeded\n product_factor: product_factor\n product_feature_1_id: product_feature_1_id\n product_feature_2_id: product_feature_2_id\n product_feature_3_id: product_feature_3_id\n product_feature_4_id: product_feature_4_id\n product_feature_5_id: product_feature_5_id\n product_feature_availability: product_feature_availability\n product_firstlistingdate: product_firstlistingdate\n product_id: product_id\n product_isin: product_isin\n product_isactivemanaged: product_isactivemanaged\n product_iscleanpriced: product_iscleanpriced\n product_iscollateralized: product_iscollateralized\n product_ispercentage: product_ispercentage\n product_isquanto: product_isquanto\n product_issueprice: product_issueprice\n product_issuer_name: product_issuer_name\n product_issuer_short: product_issuer_short\n product_lasttradingdate: product_lasttradingdate\n product_management_fees: product_management_fees\n product_maturitydate: product_maturitydate\n product_name_e: product_name_e\n product_nominalvalue: product_nominalvalue\n product_participation_level: product_participation_level\n product_payment_winscale_downside: product_payment_winscale_downside\n product_protection_level_percent: product_protection_level_percent\n product_ratio: product_ratio\n product_status: product_status\n product_style_short: product_style_short\n product_subscription_enddate: product_subscription_enddate\n product_symbol: product_symbol\n product_termsheet: product_termsheet\n product_wkn: product_wkn\n underlying_assetclass_name: underlying_assetclass_name\n underlying_component_country_name: underlying_component_country_name\n underlying_component_icb_sector_offical_id: underlying_component_icb_sector_offical_id\n underlying_component_isin: underlying_component_isin\n underlying_component_initial_fixing_currency_short: underlying_component_initial_fixing_currency_short\n underlying_component_initial_fixing_price: underlying_component_initial_fixing_price\n underlying_component_name: underlying_component_name\n underlying_component_strike_1_currency_short: underlying_component_strike_1_currency_short\n underlying_component_strike_1_percent: underlying_component_strike_1_percent\n underlying_component_strike_1_price: underlying_component_strike_1_price\n underlying_component_strike_2_currency_short: underlying_component_strike_2_currency_short\n underlying_component_strike_2_percent: underlying_component_strike_2_percent\n underlying_component_strike_2_price: underlying_component_strike_2_price\n underlying_component_strike_3_currency_short: underlying_component_strike_3_currency_short\n underlying_component_strike_3_percent: underlying_component_strike_3_percent\n underlying_component_strike_3_price: underlying_component_strike_3_price\n underlying_component_strike_4_currency_short: underlying_component_strike_4_currency_short\n underlying_component_strike_4_percent: underlying_component_strike_4_percent\n underlying_component_strike_4_price: underlying_component_strike_4_price\n underlying_component_symbol: underlying_component_symbol\n underlying_component_weight: underlying_component_weight\n underlying_compositiontype_name: underlying_compositiontype_name\n underlying_description: underlying_description\n underlying_id: underlying_id\n underlying_isin: underlying_isin\n underlying_initial_fixing_date: underlying_initial_fixing_date\n underlying_name: underlying_name\n underlying_product_id: underlying_product_id\n underlying_symbol: underlying_symbol\n migration_dependencies: { }\n """