Hi Friends,
Can you please help me??
From one table,how many joins we can give.
Thanks in advance.
No limit that I'm aware of. How many do you need?
Star Schema modelling is generally preferred while modelling in Cognos,For on of my client i have joined the Fact tables with 30 lookups.So you can create as many number of joins wrt to the id columns corresponding in your fact table.