What would cause very large row counts like this in data services data flow other than a cartesian join? (I've triple checked for this and even brought in a fresh pair of eyes) I've had this problem before and it went away after a server restart, but I have no idea why. Now it's back and restarting the server doesn't seem to have any effect. The largest table feeding the query is 4974 records.
So far I've tried to restarting the server, and compacting the repository. I'm thinking that there is a cached version of the data flow somewhere that is causing the problem.
Anyone have any ideas?
Thanks in advance.
Jon
Path Name State Row Count Elapsed T Abs Time /DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-Join3: 1 PROCEED 1443000 3166.339 3187.745 /DF_SAP_Web_Global_Customer_Address/CacheSplit PROCEED 4000 0.406 21.312 /DF_SAP_Web_Global_Customer_Address/KNA1_11 PROCEED 0 0.000 20.843 /DF_SAP_Web_Global_Customer_Address/ADRC2 PROCEED 4000 0.422 21.312 /DF_SAP_Web_Global_Customer_Address/TPART4 PROCEED 0 0.000 22.952 /DF_SAP_Web_Global_Customer_Address/CacheSplitMemoryReader PROCEED 1444000 3167.238 3188.644 /DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-Join3: 0 PROCEED 0 0.000 20.874 /DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress_SAP_GLOBAL_CUSTOMER_ADDRESS READY 0 0.000 20.343 /DF_SAP_Web_Global_Customer_Address/KNA16 PROCEED 18141000 3166.171 3189.186 /DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-JoinCache8 PROCEED 0 0.000 22.984 /DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress: 0 PROCEED 16887000 3165.375 3189.140 /DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress: 1 PROCEED 0 0.000 23.796 /DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-JoinCacheReader11 PROCEED 0 0.000 23.765 /DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-Join9: 0 PROCEED 108951000 3166.187 3189.155 /DF_SAP_Web_Global_Customer_Address/CacheSplit[1] PROCEED 0 0.000 22.952 /DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-Join9: 1 PROCEED 18140000 3166.094 3189.124 /DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-JoinCache12 PROCEED 0 0.000 23.780 /DF_SAP_Web_Global_Customer_Address/KNVP10 PROCEED 0 0.000 23.796 /DF_SAP_Web_Global_Customer_Address/CacheSplitMemoryReader[1] PROCEED 108952000 3166.219 3189.171 /DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-Join5: 0 PROCEED 1184000 3165.459 3188.396 /DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-JoinCacheReader7 PROCEED 0 0.000 22.968 /DF_SAP_Web_Global_Customer_Address/Query_GlobalCustomerAddress-Join5: 1 PROCEED 108951000 3166.141 3189.109