Different dimension level from different source?

I need to load files from different source. They may provide different
granularity of dimensions. For example, there is a dimension table
Location:

LocationKey, zip, city, state, ....

Some source can provide zip for the fact table, but some can only
provide city or state. What's the best way to handle this? Create some
pseudo zip codes to whole citis and whole states? Or give each city a
default zip and each state a default zip/city and add a flag to
indicate the missing of zip and city?

Thanks,

Hello

Maybe a Parent Child dimension with non leaf menbers with data.
--
Ricardo Junquera
Consultor Business Intelligence

BG&S Online Consultores
Ganadora del Premio Microsoft Business Awards 2008.
Partner de Soluciones : Satisfacción de Cliente.



"nkw" wrote:

> I need to load files from different source. They may provide different
> granularity of dimensions. For example, there is a dimension table
> Location:
>
> LocationKey, zip, city, state, ....
>
> Some source can provide zip for the fact table, but some can only
> provide city or state. What's the best way to handle this? Create some
> pseudo zip codes to whole citis and whole states? Or give each city a
> default zip and each state a default zip/city and add a flag to
> indicate the missing of zip and city?
>
> Thanks,
>