How cube is making join data source

How cube is making join in multiple data sources and building .mdc file and preparing package.

Cognos transformer has unique mechanism to gather multiple data sources (Reports, IQD's (Queries), model, packages) to build cube.

Question is how transformer doing magic
Are we define any join one IQD's to another IQD's ?
Are we define any join between two tables?
Are we define any join between two database?


After cube published .mdc file In power play studio we can do analysis using those all dimensions.
All dimensions made based on unlinked data sources, how this magic?

Answer : Cube machanism search in backgroud to join one table to anther by just finding common column, and same also doing in case for multiple databases. it will gather common column join to each other.


Thanks.