Hi,
we need some suggestion on dividing the string using substring function with delimited value.
for this dividing the string which we have in specific column, we are trying to follow below 2 steps
1. create a calculation in data source query subject to dividing the string.
2. create a model query subject and dividing the string in this model qs.
which one is the better one? please suggest me
You want to avoid metadata callbacks. That's why you want the query layer query subjects to be in the form select * from. The query engine then only needs to get metadata from the metadata stored in the query layer.
You want to have your business expressions in your business layer.
Or better yet, modify your database to store the column and have the ETL perform the string manipulation.