how manage large data in Dimension field in Direct Discovery Method

[Anonymous]

Hi

I have Table in my app that have 40 billion records (it is about bank's transaction)

I loaded this table by Direct Discovery Method

(Direct Query

Dimension

        Account_ID,

        Transaction_Date

  Measure

        Amount

From MyTable)

but have problem with Dimensions because the Dimension Data volume is about 60 million records for Account_ID Dim

and the Reload time is more than 20 hours !!!!!!

and the app is too slow

thanks for new data model or suggestions

[Anil_Babu_Samineni]

May be try this?

DIRECT QUERY

DIMENSION

Account_ID

Transaction_Date

MEASURE

Amount