Print Page - Transfomer with different data source

Title: Transfomer with different data source
Post by: madhancog on 06 Jul 2009 05:44:12 AM

Hi ,
I have created an iqd file in FM and in that one iqd file contains emp id.
I have one more iqd file that was generated from Impromptu that to contains emp id.
Is it possible to use these two emp id from different source in single model and get the data ?
Pls let me know

KRs,
K.M

Title: Re: Transfomer with different data source
Post by: vij on 08 Jul 2009 05:26:22 AM

HI madhancog ,
yes you can use that.
In transformer you can use Excel ,iqd,Access tables,csv files as data sources in the same model itself.

regards,
vij
:)

Title: Re: Transfomer with different data source
Post by: madhancog on 13 Jul 2009 04:50:06 AM

Thanks for your reply
My question is when we have 2 emp id one from one iqd and another from next iqd which will be used and how it will work?
Pls let me know

Regards,
K.M

Title: Re: Transfomer with different data source
Post by: Mpotla on 21 Aug 2009 07:05:40 AM

Hi ,

suppose u have two files, for the same employee deatils, u can do the Union and show the values from both the IQDs in the same coulumn. U need not to do UNION operation Explicitly, Just keep the same name for the emplyee coulumn in both the iqds, It will automatically do UNION of the values and shows it in the same field.

Thanks
MC

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: madhancog on 06 Jul 2009 05:44:12 AM