Alternative approach for Bridge table (for better performance)

[madhubabum]

Hi Experts,

In my case, I am using "Bridge Table".(But it is taking long time to reload the data model).

Is there any alternative approach ?

Please suggest to me...

Thanks,

Madhu

[HirisH_V7]

Hi,

Means link tables ,

With so many Fact tables? Slowly Changing Dimensions.

or

Date fields more than two, such as canonical Dates .

Can your explain example of your Data Model!!

-Hirish

[Anonymous]

Bridge Tables?

[settu_periasamy]

Re: link table

[mithilesh17]

Hi,

Try Concatenate in your scenario. All fields take into one table.

Regards.

[jagan]

HI,

Attach some sample data so that it would be easier to suggest the solution, otherwise it is difficult.

Regards,

Jagan.

[vinieme12]

Bridge table isn't the problem, it depends on how your script your data load