Using my first set of QVDs I want to tranform some data and load this at an aggregated level.
My first set of QVDs is at a very low granularity, I have few flags derived at that granularity but would need the data only for flag =1 .
QVD at detailed level
Month Account Num Flag Amount
1 xx 1 10
1 yy 0 20
Summary QVD (where flag =1 )
Can I do a preceding load where I have only the data for flag = 1?
Thank you all.
I realised that there are more measures, some measures I need to bring it for both flag 0 and 1 and some with flag 1.
By using the where flag = 1 wouldnt work in this case.
Whats the best approach at the script level?
Is it a case of doing 2 loads one for flag = 1 and one without and concatenate?