I assume that you don't need the exact filetime else an approximately value will fulfil the purpose, too. In this case you may add this value already by the creation of the qvd, for example with now(). Another possibility would be to fetch this value before loading from the qvd - filetime() and also qvdcreatetime() could be assigned to a variable which is then used within the load.
Beside this by a qvd load which returns about 63 M of records from n more records of the source it would be helpful to keep the load optimized - means avoiding of any processing of the data. In this sense you may replace the where match() with a where exists() and the mentioned filetime might be integrated in beforehand or probably even better removed - at least as information directly within the qvd. Like above mentioned this information could be accessed from anywhere it's needed and should any timeline be tracked it might be done within a parallel process/loading. Should there be more transformations within this load I could imagine to solve them in a different way, too.
- Marcus
