Share
Report
3,002Hi Tech experts,
Greetings for the day.
We need to created a data entity for exporting data which have lot of fields. Entity has lot of fields which will be assigned with more complex calculations, not having simple assignment with getting data from tables.
To skip stagging data, in order to increase performance, we tried to create computed fields but it looks like not possible due to complex calculations. So created virtual fields in data entity for this purpose. Find attached screenshot for reference. where the three of the fields are assigned with output of the business logic.
Some of the fields will have bit more complex calculations with lot of checks to get the values.
I've few queries on this requirement, could you please share your experience
1) Is there possibility of using computed columns instead of virtual fields here? If yes, please do let me know how to handle above complex code with computed sql methods. Please write logic for computed method for above code if possible or share any online article which has similar complex code.
2) Is there any work around of skipping stagging data while exporting when virtual fields exist, modifying or overriding methods?
3) Any other work around with data entity with skipping stagging data, to increase performance while exporting data.
Highly appreciate your tech expertise on this and thanks in advance.
I have the same question (0)
All responses (
Answers (
