Flat file load to BI 7 cube
Does the Position of fields in the Transformation in BI 7 have to be the same as the sequence of fields in the Datasource?
I'm trying to load a flat file but my first field in the DS and flat file is a 4 char field. In the PSA, it only shows 2 characters and truncates the rest.
I checked the transformation and the 1st position is of a field that is a CHAR 2.
How can I change the position of the field in the transformation?