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?
No need to change anything in the transformation. Just make sure that the order of fields in the flat file datasource matches the file and the data types and lengths defined in the datasource are correct.