Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => BI Modeling (Transformer) => Topic started by: consultantcareer on 09 Oct 2008 05:13:31 PM

Title: how to feed union of two data sources to Transformer
Post by: consultantcareer on 09 Oct 2008 05:13:31 PM
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
Title: Re: how to feed union of two data sources to Transformer
Post by: twlarsen on 17 Oct 2008 10:16:57 AM
Why not union them in one of the databases and then have the IQD use that union view?
Title: Re: how to feed union of two data sources to Transformer
Post by: billylodz on 17 Oct 2008 03:23:12 PM
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)
Text only | Text with Images