Hi,
How to get unmatched records in cognos 10.2.2?
Query1 gettting data from Oracle Db and Query2 getting from teradata, both queries having same columns and same data.
I need to retrieve where data is unmatched and missing records. I am trying using set operators. If anyone has any ideas would be appreciated.
Thanks,
Priya
Quote from: priya@90 on 17 Dec 2019 07:16:03 AM
Hi,
How to get unmatched records in cognos 10.2.2?
Query1 gettting data from Oracle Db and Query2 getting from teradata, both queries having same columns and same data.
I need to retrieve where data is unmatched and missing records. I am trying using set operators. If anyone has any ideas would be appreciated.
Thanks,
Priya
Have you tried using an Except between the two queries? It sounds like this is what you need?
MF.