Outer Join in Multi-Source Universes

[Former Member]

Hi,

We have three source systems SAP BW, DB2 and Teradata.

we are doing left outer joins on BW and Teradata  to get all BW records plus matching Teradata records.

Similarly we are doing left outer join on DB2 and Teradata to get all DB2 records plus matching Teradata records.

But in both of the above scenarios the result set does not pick Teradata records.

I guess unlike single source universe, Data Federation Query engine takes care of converting SQL to respective source system format.

I have even tried setting ANSI_92 , FILTER_IN_FROM and OUTERJOINS_GENERATION parameters but no luck.

Do i need to edit or set any other options?

Thanks,

Vishal

[Former Member]

Hello Vishal,

Did you check the Teradata Query in DFT?  I would recommend you to manually copy matching data from either DB2/BW as well as Teradata and paste in Excel and check if there is any special characters being added.

Regards,

Laxminarayana