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 |
|
Ravi0435
Starting Member
47 Posts |
 Posted - 2007-05-24 : 09:58:52
|
| Hi, I selected the columns which i need in the data source itself and i need 3 columns,one will direclty go to the destination without any change/transformation and about the other two i need to do few lookups.When i try to do lookup for One column which has the datatype in the source as nchar(3) though the date in the column is a number(like 150,160,170 and so on), my lookup table(a dimension in DW) where i want to get the actual key by looking up with this number doesnt allow me to map to the dimension in the DW, as the Dimension has this column datatype as decimal (3,0)....i tried the datatype conversion to convert the nchar to decimal but it doesnt transform i dont know why...probably i am doing some mistake...Could someone suggest how to deal with this and which transformation to use..?I'd really appreciate if someone on this forum suggest how to deal with this..? thanksraviNothing much that i can do..!! |
|
|
Ravi0435
Starting Member
47 Posts |
Posted - 2007-05-24 : 10:35:13
|
Hey, I got that thing working....!! Finally was done by data type conversion transformation task.....lemme know if the way i did is bad and if there is any other efficient way of doing it.? thanks,raviquote:
Originally posted by Ravi0435
Hi, I selected the columns which i need in the data source itself and i need 3 columns,one will direclty go to the destination without any change/transformation and about the other two i need to do few lookups.When i try to do lookup for One column which has the datatype in the source as nchar(3) though the date in the column is a number(like 150,160,170 and so on), my lookup table(a dimension in DW) where i want to get the actual key by looking up with this number doesnt allow me to map to the dimension in the DW, as the Dimension has this column datatype as decimal (3,0)....i tried the datatype conversion to convert the nchar to decimal but it doesnt transform i dont know why...probably i am doing some mistake...Could someone suggest how to deal with this and which transformation to use..?I'd really appreciate if someone on this forum suggest how to deal with this..? thanksraviNothing much that i can do..!!
Nothing much that i can do..!! |
 |
|
|
|
|
|
|
|
nchar to decimal..which transformation