Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello
i have 1 table which is contain South, North, West, East data,i want to show data for only North region but i dont want to used where condition in it then how it is possible by using optimize way.
Thanks..
We need more information to answer your question.
i have 1 table
region:
LOAD South,
North,
West,
east
FROM News;
i want to show data only from North region in optimize way without using where condition.
ok. but optimezed for what purpose? script execution time? Server memory? Client performance?
ok leave it that optimize, just tell me only without where
Its dificult to understand your question, and why using "Where" is not an option.
but from you example code - if dimensions west, east and south are to be ignored, just do a distinct load and remove dimensions not wanted.
load Distinct
north
from news;
actually i faced this scenario in interview
ah, ok.
perhaps they mean you want to keep qvd-optimized load but the Where clause causes the load be not qvd-optimimized... its a normal interview question...
if this is what they mean, the best practice is to do this, it will be very fast load:
temp_opt:
load region, field1, field2,field3 from news.qvd;
news:
noconcatenate
load field1,field2, field3 resident temp_opt where region='North';
drop table temp_opt;
but he said without using any condition in where clause.
hmmm....
i guess you could potentially write a if statement in the script to force all non North transactions to become Null values but that would make no sense, and would just slow down the load process alot...
....without a where clause in the load script, all loaded data will exist in the data model after the load is complete, and exclusions of regions will have to be done in the user-interface instead by using on-open-triggers or by more or less forced user selections, or in chart expressions by using set-analysis.