How to Skip Entire column from Source file while load MD from Flat file in BPC

[Former Member]

Hello Experts,

I am loading flat file MD and noticed there is some BPC limitation. For example I have one property "ABC" in dimension and source file also have the same property name "ABC". I do not want to bring that property data and I did not mapped this property in transformation file. If the property name is exactly same in both source and Dimension, then system reads it and updates property "ABC" in dimension.

Is there any way I can skip "ABC" while loading MD using DMP.

Your input highly appreciated.

Inaam

[Former Member]

Hi Inaam,

I have never seen such case where the fields are auto updated without mapping with flat file! Have you tried skipping the headers from flat file? or remove the headers and then tested?? Might work.....

Regards,

JP

[Former Member]

Thank you so much JP for your input. I tried that too but it was not working. Below Vadim has given a solution and it works.