my Data Source View connects to an Oracle database via Oracle Provider for OLE DB,
and there is a dimensional table named DIM_CITY, and one of its columns , city_id has the integer oracle type.
if i directly add this table as a table to my DSV, the datatype of city_id in DSV would be System.Int64, which i think is appropriate. if i use it from within a named query(SELECT a.*,b.province_name FROM dim_city left join dim_province b on a.province_id=b.province_id),
then the datatype of city_id is System.Int32, which causes troubles as i can NOT add relationships when city_ids in other tables are of type of System.Int64.
any suggestions will be appreciated.
Interested in BI related technologies
View Complete Post