Skip to Content
0
Former Member
Apr 23, 2009 at 11:23 AM

query on InfoSet

16 Views

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.