how to join multiple dimension table to single fact table

[vipingarg23]

Hi Team,

I have one fact table which is having 36 crore records, and have 4 dimension tables. I need to do inner join 4 dimension table to one fact table. As fact table is having 36cr record, it is taking too much time for below code:

Fact:

Inner Join(Fact)

DimensionA

Inner Join(Fact)

DimensionB

Inner Join(Fact)

DimensionC

Inner Join(Fact)

DimensionD

Can anyone correct me on the same?

[PrashantSangle]

your code is correct.

but is it necessary to do inner join dimension table to fact table??? you can keep it on association.

if it is necessary to join then take only required field from dimension table because high number of columns will impact on you script load.

Regards,

[vipingarg23]

Thanks Prashant For your suggestion..