Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning,
I am loading a qvd with a where exists statement and I would like to find out, if it is beeing loaded as "optimized" qvd load.
In the log I can't figure that out? It is not stated there:
2019-11-26 17:58:37 0145 where exists(date)
2019-11-26 19:51:55 22 fields found: fact, date, sk_product, sk_country, sk_customer, sk_procedure, sk_activity_type, sk_activity_team, sk_contact, sk_activity_user, activity_id, currency code, sk_sales_segmentation, call_segmentation_id, sk_activity_channel, SK_KEY_REP, CustomerFacing_Flag, sales, version, bp sales, commercial, non_strat_flag,
2019-11-26 19:51:55 83,977,327 lines fetched
Try to create as
1) Load Source data into model
2) Store into QVD
3) Load again
4) Try to notice, What is the time for reload the app using direct source / QVD load?
5) Check the size of QVD and source as well