I'm trying to load one of the dimension table into my DW, but it's throwing this error:
Detail Message: Incompatible operand types Float and String
On my datasource table I have 3 income fields (all Floats), and in my DW all 3 are also float. So I don't get it why it's saying string and float.
Any idea of what might be? Thanks!
1 - if the output table existed and stil has its old structure (create table if not exist)
2 - A variable you read is float but a function returns a string, most likely if you use a tMap to do stuff.
3 - You have == (equality test) when you want = (assignment).