Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vaddi
Posting Yak Master
145 Posts |
 Posted - 2007-05-31 : 12:19:48
|
| Hello,I have source table with columsn, Flight ID , Starting From , Destination. I bring them to a flat file ( i.e to a text file) and then loading into the dataware house dimension table. while I am mapping the columns , it gives me an error " data type does not match" when I try to map the Flight ID. The starting from and destination columns are mapping good.I have given the same datatype for Flight ID both in the source table and dimensional table i.e integer.What might be going wrong.Thanks |
|
|
|
|
|
Error - Datatype mismatch in Dimension Table