First try with mapping function

[#1]

Hi there,

I would like to remane some records in a field that's why I used MAPPING function. I put that script just before to load the concerned table.

MAPPING:

MAPPING LOAD *  inline [

Old ,New

"char 1", "new char 1"

"char 2", "new char 2"];

map

[fieldName] using MAPPING;

But nothing happened..

Any ideas?

Thank you.

[#2]

Perfect. Thank you for your help. It works with the clause but i guess I should find a better way (like doing the mapping before to creating the QVD file) in order to keep the optimize load.

Thank you !