Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FDM TDATASEG segment number for a location

user17Jun 10 2017 — edited Jun 13 2017

All,

This is related to FDM.

In order to retrieve the data from the database for a location, we need to know the location’s segment number. This will then give us the name of the table for the data segment eg tDataSeg4 or tDataSeg23. From where can i get the segment number for a particular location? Does this reside as a column in any table so that I can lookup?

I have 50 tdataseg tables in my FDM db. How can i lookup for data for a particular location? How do I know which tdataseg table contains the data for the required location?

Alternatively, I can query all the 50 tDataSeg tables and look up for the data for a particular location using partition key tagged to a location. But that's time consuming.

Thanks,

@"Francisco Amores"@"JohnGoodwin"

Sai

This post has been answered by SH_INT on Jun 12 2017
Jump to Answer

Comments

SH_INT
Answer

You need to look in the tPOVPartition table (which is the FDM table that stores all the location related information). There is a field in this table which tells you the numer of the tDataSeg table used by each location

Marked as Answer by user17 · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 10 2017
Added on Jun 10 2017
1 comment
322 views