Joins

[dwsiva]

Hi Friends,
Can you please help me??
From one table,how many joins we can give.

Thanks in advance.

[almeids]

No limit that I'm aware of.  How many do you need?

[Arpitagrawal9]

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.