Need Suggestions on String divide using substring function

[jeeva]

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

[bus_pass_man]

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.

[Lynn]

Or better yet, modify your database to store the column and have the ETL perform the string manipulation.