Hi,
I was wondering has anyone exported data from a database to a file and used these files to read into Cognos Transformer. If you did; Did it reduce the time to build the Cubes and did it reduce the overall time it took to create the cubes between the two options below:
Option (1) to run the iqds(the iqds have many joins) off the database and create the cube
Option (2) to export the data to the files, read in the files and creating the cubes
If you did use option (2), were there any other reasons (omitting performance issue)why you used this option?
Any ideas!
Thanks in advance
Canhe
I was wondering has anyone exported data from a database to a file and used these files to read into Cognos Transformer. If you did; Did it reduce the time to build the Cubes and did it reduce the overall time it took to create the cubes between the two options below:
Option (1) to run the iqds(the iqds have many joins) off the database and create the cube
Option (2) to export the data to the files, read in the files and creating the cubes
If you did use option (2), were there any other reasons (omitting performance issue)why you used this option?
Any ideas!
Thanks in advance
Canhe