Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how manage large data in Dimension field in Direct Discovery Method

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

1 Reply
Anil_Babu_Samineni

May be try this?

DIRECT QUERY

DIMENSION

Account_ID

Transaction_Date

MEASURE

Amount

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful