If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

unmatched records

Started by priya@90, 17 Dec 2019 07:16:03 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

priya@90

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

MFGF

#1
17 Dec 2019 07:19:04 AM
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.
Meep!
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite