on 07-24-2014 11:27 AM
Hi experts, I would like to know if it is possible to make a tranformation or conversión of data when a data file is Exporting. I mean, I'm trying to EXPORT (through Data Manager > Run a data managment package > Data Managment > Export from fact table) But we need include a extra column with a constant, on the result file, and also, eliminate another column (this dimensions arent in target) I tried to use de Tranformation Command *SKIP as well as a Conversion File with External and Internal Values, but it doesn't work. And all the documentation is about Import a file, and it never regards to a Export Files. So we want to add a new column "VERSION" with the constant value "V_BAS" And eliminate the dimension (column in flat file) AUDITID Any advice? Thanxs!!!
Hi Monica,
can you please share your transformation and conversion files?
which version are you using?
Regards
Roberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.