I have a Scenario as Below:
There are some dump values in the Currency Field from Source System.
Inorder to get rid of that , I have a scenario where i can lookup the Value for Currency Based on Company Code from 0COMP_CODE and Replace the Currency Value Respectively in Transformation and Load into ADSO.
Can anybody Help on this.
Thanks in Advance