Hi Guys,
Need to create a model involving tables from 3 or more different schemas. The schemas are in same database DB2. will it have performance issue? Any best practice to overcome that?
Appreciate your help!
Well you'd need to make sure that there are relationships between the appropriate objects in any schema with the related objects in the other schemas lest you end up with cross-joins.
The answers in http://www.cognoise.com/index.php/topic,32212.0.html are valid for FM too.
With all other things being equal, having your reporting data base in a well-tuned data warehouse is best.
You don't say what structure your data base is -- whether it's a dw or transactional. The latter would be slower than the former usually.
I agree; why does your DBA or data warehouse architect give you three schemas to get your data from? Usually your query layer (preferrably data marts with stars) will be in one schema.
Or could you create aliases so Cognos see it as all 1 schema