How to Union two Target tables with similar structure in Data Federator

[Former Member]

Hi experts,

I am new to Data Federator and ran into a problem. In my DF project, I have created 2 target tables with similar structure. Each target table is returning expected result. My question is how to union data from these 2 target tables in Data Federator to provide a single target table?

Any idea is appreciated.

Thanks,

Joyce

Edited by: Joyce Chan on Mar 10, 2011 4:47 PM

[Former Member]

Problem solved by creating 2 mapping rules, one of each source table.

[Former Member]

Hi,

You might be able to create a Derived table with a Union statement using these two tables. Then join to the derived table.

Hope this helps,

Mike