Hi ,
I am trying to make a snap which replaces the simple sub-query . However I was not getting the proper count at the output . After knowing about the types of joins in snaplogic , I tried using them but the count is not in sync . Can I know what went wrong . Please find the sample files and sub-query used.
VV_ACT_CALL_DISCUSSION_EXTRACT.xlsx (814.1 KB) ------For the table “VV_ACT_CALL_Discussion_EXTRACT_ID”
VV_ACT_CALL_DETAIL_EXTRACT.xlsx (753.8 KB) ------For the table “VV_ACT_CALL_DETAIL_EXTRACT_ID”
Query used:
SELECT DISTINCT A.“Call_Detail_ID”,
A.“Call_ID”,
A.“Product_ID”,
A.“Country_Code”,
A.“Priority”,
A.“Type”,
A.“Is_Deleted”,
A.“Created_date”,
A.“Created_By_Id”,
A.“Last_Modified_Date”,
A.“Last_Modified_By_Id”
FROM VV_ACT_CALL_DETAIL_EXTRACT_ID A WHERE A.“Product_ID” NOT IN (SELECT B.“PRODUCT_ID” FROM VV_ACT_CALL_Discussion_EXTRACT_ID B
WHERE B.“CALL_ID” = A.“Call_ID”)-------Count in Oracle 2263 whereas in Sanp I get around 10K
Please let me know so that I can also attach my snap.
Thanks,
Harshavardhana
