Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try this?
DIRECT QUERY
DIMENSION
Account_ID
Transaction_Date
MEASURE
Amount