ProjectNode + Output Columns: 0: BUSINESSDATE (date) 1: CURRENCYCODE (string) 2: LEDGERPRODUCTDESCRIPTION (string) 3: LEGALENTITY (string) 4: CLEARINGTYPE (string) 5: COUNTERPARTY (string) 6: ALTERNATECONTRACTID (string) 7: HCSENTITY (string) 8: COSTCENTRE (string) 9: PRIMARYCONTRACTID (string) 10: ROOTCONTRACTID (string) 11: ASSETAMTTRADE (bigdecimal) 12: LIABILITYAMTTRADE (bigdecimal) 13: TOTALNETTING (bigdecimal) 14: CCNETTINGBENEFITCCY (bigdecimal) 15: TOTALADNLNETTINGCCY (bigdecimal) 16: ADDITIONALNETTING (bigdecimal) 17: TOTALNETTINGCC (bigdecimal) 18: APPORTIONEDAMOUNT (bigdecimal) 19: TOCURRENCY (string) + Statistics: 0: Node Output Rows: 10453502 1: Node Process Time: 74 2: Node Cumulative Process Time: 2203633 3: Node Cumulative Next Batch Process Time: 630220 4: Node Next Batch Calls: 34589 5: Node Blocks: 14172 + Cost Estimates:Estimated Node Cardinality: -1.0 + Child 0: JoinNode + Output Columns: 0: BUSINESSDATE (date) 1: CURRENCYCODE (string) 2: LEDGERPRODUCTDESCRIPTION (string) 3: LEGALENTITY (string) 4: CLEARINGTYPE (string) 5: COUNTERPARTY (string) 6: ALTERNATECONTRACTID (string) 7: HCSENTITY (string) 8: COSTCENTRE (string) 9: PRIMARYCONTRACTID (string) 10: ROOTCONTRACTID (string) 11: ASSETAMTTRADE (bigdecimal) 12: RATE (bigdecimal) 13: LIABILITYAMTTRADE (bigdecimal) 14: TOTALNETTING (bigdecimal) 15: CCNETTINGBENEFITCCY (bigdecimal) 16: TOTALADNLNETTINGCCY (bigdecimal) 17: ADDITIONALNETTING (bigdecimal) 18: TOTALNETTINGCC (bigdecimal) 19: APPORTIONEDAMOUNT (bigdecimal) 20: TO_CURRENCY (string) + Statistics: 0: Node Output Rows: 10453502 1: Node Process Time: 2203120 2: Node Cumulative Process Time: 2203559 3: Node Cumulative Next Batch Process Time: 565471 4: Node Next Batch Calls: 34589 5: Node Blocks: 14172 + Cost Estimates:Estimated Node Cardinality: -1.0 + Child 0: AccessNode + Output Columns: 0: CURRENCYCODE (string) 1: BUSINESSDATE (date) 2: LEDGERPRODUCTDESCRIPTION (string) 3: LEGALENTITY (string) 4: CLEARINGTYPE (string) 5: COUNTERPARTY (string) 6: ALTERNATECONTRACTID (string) 7: HCSENTITY (string) 8: COSTCENTRE (string) 9: PRIMARYCONTRACTID (string) 10: ROOTCONTRACTID (string) 11: ASSETAMTTRADE (bigdecimal) 12: LIABILITYAMTTRADE (bigdecimal) 13: TOTALNETTING (bigdecimal) 14: CCNETTINGBENEFITCCY (bigdecimal) 15: TOTALADNLNETTINGCCY (bigdecimal) 16: ADDITIONALNETTING (bigdecimal) 17: TOTALNETTINGCC (bigdecimal) 18: APPORTIONEDAMOUNT (bigdecimal) + Statistics: 0: Node Output Rows: 14510117 1: Node Process Time: 892860 2: Node Cumulative Process Time: 892860 3: Node Cumulative Next Batch Process Time: 10925 4: Node Next Batch Calls: 42512 5: Node Blocks: 14171 + Cost Estimates:Estimated Node Cardinality: -1.0 + Query:SELECT g_0.CURRENCYCODE AS c_0, g_0.BUSINESSDATE AS c_1, g_0.LEDGERPRODUCTDESCRIPTION AS c_2, g_0.LEGALENTITY AS c_3, g_0.CLEARINGTYPE AS c_4, g_0.COUNTERPARTY AS c_5, g_0.ALTERNATECONTRACTID AS c_6, g_0.HCSENTITY AS c_7, g_0.COSTCENTRE AS c_8, g_0.PRIMARYCONTRACTID AS c_9, g_0.ROOTCONTRACTID AS c_10, g_0.ASSETAMTTRADE AS c_11, g_0.LIABILITYAMTTRADE AS c_12, g_0.TOTALNETTING AS c_13, g_0.CCNETTINGBENEFITCCY AS c_14, g_0.TOTALADNLNETTINGCCY AS c_15, g_0.ADDITIONALNETTING AS c_16, g_0.TOTALNETTINGCC AS c_17, g_0.APPORTIONEDAMOUNT AS c_18 FROM CE_Source.CE_CCN_REPORTING_T AS g_0 ORDER BY c_0, c_1 + Model Name:CE_Source + Child 1: DependentAccessNode + Output Columns: 0: FROM_CURRENCY (string) 1: BUSINESS_DATE (date) 2: RATE (bigdecimal) 3: TO_CURRENCY (string) + Statistics: 0: Node Output Rows: 459 1: Node Process Time: 439 2: Node Cumulative Process Time: 439 3: Node Cumulative Next Batch Process Time: 0 4: Node Next Batch Calls: 2 5: Node Blocks: 1 + Cost Estimates:Estimated Node Cardinality: 1.0 + Query:SELECT g_0.FROM_CURRENCY AS c_0, g_0.BUSINESS_DATE AS c_1, g_0.RATE AS c_2, g_0.TO_CURRENCY AS c_3 FROM FDM_Source.WH_GL_DAILY_RATES_F AS g_0 WHERE (g_0.CONVERSION_TYPE = 'Spot') AND (g_0.TO_CURRENCY = 'STG') AND (g_0.FROM_CURRENCY IN ()) AND (g_0.BUSINESS_DATE IN ()) ORDER BY c_0, c_1 + Model Name:FDM_Source + Dependent Join:true + Join Strategy:MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED) + Join Type:INNER JOIN + Join Criteria: 0: CE_Source.CE_CCN_REPORTING_T.CURRENCYCODE=FDM_Source.WH_GL_DAILY_RATES_F.FROM_CURRENCY 1: CE_Source.CE_CCN_REPORTING_T.BUSINESSDATE=FDM_Source.WH_GL_DAILY_RATES_F.BUSINESS_DATE + Select Columns: 0: CE_Source.CE_CCN_REPORTING_T.BUSINESSDATE AS BUSINESSDATE 1: CE_Source.CE_CCN_REPORTING_T.CURRENCYCODE AS CURRENCYCODE 2: CE_Source.CE_CCN_REPORTING_T.LEDGERPRODUCTDESCRIPTION AS LEDGERPRODUCTDESCRIPTION 3: CE_Source.CE_CCN_REPORTING_T.LEGALENTITY AS LEGALENTITY 4: CE_Source.CE_CCN_REPORTING_T.CLEARINGTYPE AS CLEARINGTYPE 5: CE_Source.CE_CCN_REPORTING_T.COUNTERPARTY AS COUNTERPARTY 6: CE_Source.CE_CCN_REPORTING_T.ALTERNATECONTRACTID AS ALTERNATECONTRACTID 7: CE_Source.CE_CCN_REPORTING_T.HCSENTITY AS HCSENTITY 8: CE_Source.CE_CCN_REPORTING_T.COSTCENTRE AS COSTCENTRE 9: CE_Source.CE_CCN_REPORTING_T.PRIMARYCONTRACTID AS PRIMARYCONTRACTID 10: CE_Source.CE_CCN_REPORTING_T.ROOTCONTRACTID AS ROOTCONTRACTID 11: (CE_Source.CE_CCN_REPORTING_T.ASSETAMTTRADE * FDM_Source.WH_GL_DAILY_RATES_F.RATE) AS ASSETAMTTRADE 12: (CE_Source.CE_CCN_REPORTING_T.LIABILITYAMTTRADE * FDM_Source.WH_GL_DAILY_RATES_F.RATE) AS LIABILITYAMTTRADE 13: (CE_Source.CE_CCN_REPORTING_T.TOTALNETTING * FDM_Source.WH_GL_DAILY_RATES_F.RATE) AS TOTALNETTING 14: (CE_Source.CE_CCN_REPORTING_T.CCNETTINGBENEFITCCY * FDM_Source.WH_GL_DAILY_RATES_F.RATE) AS CCNETTINGBENEFITCCY 15: (CE_Source.CE_CCN_REPORTING_T.TOTALADNLNETTINGCCY * FDM_Source.WH_GL_DAILY_RATES_F.RATE) AS TOTALADNLNETTINGCCY 16: (CE_Source.CE_CCN_REPORTING_T.ADDITIONALNETTING * FDM_Source.WH_GL_DAILY_RATES_F.RATE) AS ADDITIONALNETTING 17: (CE_Source.CE_CCN_REPORTING_T.TOTALNETTINGCC * FDM_Source.WH_GL_DAILY_RATES_F.RATE) AS TOTALNETTINGCC 18: (CE_Source.CE_CCN_REPORTING_T.APPORTIONEDAMOUNT * FDM_Source.WH_GL_DAILY_RATES_F.RATE) AS APPORTIONEDAMOUNT 19: FDM_Source.WH_GL_DAILY_RATES_F.TO_CURRENCY AS TOCURRENCY