query items

[cogboy]

Hi everyone


I have a issue with my project.
when i started creating my query items all column names are existing as values in a single table.what should i do.all my query items are coming from a single table and form same column.
1)do i create query for each query item/have etl process before FM work
2)will my metadata perfomance decrease do to such modelling.

[MFGF]

Hi,

I'm not quite sure I follow what you're saying here.  Are you saying all your data is stored in a single column of a single table?

MF.

[cogboy]

Hi MF

Thanks for replying

yes, all my query items of particular querysubject have same source column and source table.Almost all of my query subjects are based upon this table.

Thanks

cogboy

[MFGF]

Hi,

In that case, your options would either be to
a: create a query subject for each logical item, filtering the source table accordingly in each, then merge these into a more usable structure at the next level of modelling, or
b: use an ETL tool to re-structure the data into more a more usable format, them import the definitions of these tables/items.

In terms of efficiency, b would be better than a at runtime.

Regards,

MF.

[cogboy]

Hi MF

I appreciate you in geeting back to me.

Do you think creating 140 query subjects to get 140 logical items (query items) will reduce the performace. ???


Thanks
cogboy

[MFGF]

Hi,

Almost certainly.  It will obviously take some work if you restructure the data in the database, but it will give you much better performance at runtime than if you leave the current structure as it is and try to resolve in Framework Manager.

Regards,

MF.