โ02-12-2021 10:32 PM
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