how to feed union of two data sources to Transformer

[consultantcareer]

hi Gurus,

I need to feed union of Data from Oracle and Sql server to Transformer. IQDs does not support multiple data sources.

What I am trying to do is get the CSV extract of the whole union and feed it into the cube.

these CSV files grow too large and exceeds the maximum limit supported (2GB).
Cube must be updated daily and can not be incrementally updated due to data requirement.

Is there any other way to achieve this union except for CSV files.

Any inputs/Ideas are appreciated,
Thanking in Advance

[twlarsen]

Why not union them in one of the databases and then have the IQD use that union view?

[billylodz]

I have model with 2 iqd's for facts, the fact tables are the same on 2 different servers ( in fact both are SQL but it shouldn't be problem)