Hi,
Is it possible to consider,
ODS1 Contains 200 records and ODS2 contains 50 records. And ODS1 contains 2 key figures and ODS 2 Contians another 3 key figures.
Let us say out of 200 records from ODS1 40 records are matching in ODS2. then I want to show the 40 records which match from ODS1 TO ODS2 And remaining 160 records from ODS1 with remaining 3 key figure values (which comes from ODS2) as blank in query result. Because we don't have the records for these 160 records.
Requirement is I want the records which matches from ODS1 in ODS2 and remaining records in ODS1 also. Just I don't want the show the records which does not match in ODS1, here 10 records in ODS2 which does not match in ODS1 records. hence I don't want to show those 10 records in my report.
Please suggest.