Map..Using (mapping) fucntion Info please..

[#1]

Any one help me how to understand mapping function i.e Map Using?????

[stevedark]

Hi Adnan,

I never use Map Using (favouring ApplyMap instead) so I have not seen this issue.

If I had to guess what is going on, it is because the QVD is doing an optimised load and therefore isn't checking the mapping field.

Try:

Test2:

Load

RuleXXX

From

[Test1.qvd](qvd)

WHERE 1=1;

The additional line will break the optimised load, and may cause the map to work.

Steve

[adnan_rafiq]

You are right Steve,

It looks a little an extra line but does not make sense,  why un-optimized would make the map work.

Thanks

[stevedark]

I love it when a total guess turns out to be correct. 

Thanks for letting me know.