I want to calculate a field in the load script like EMP_Salary * Exchange_Rate. But I don't know the proper syntax.
Do I use an INLINE load? Do I need to use RESIDENT? Do I need to create and then drop a temporary table? Do I need to have both tables load before I can complete these calculations? Could someone please provide a simple example that illustrates and explains these things. I can't figure them out from other posts. Thanks.
Thanks for the reply. This helps, but when I use a mapping load it drops the table automatically after script execution. How can I accomplish the same thing if I have a larger table than Exchange_Rates and I don't want it dropped?
Do mean load Exchange_Rates twice--once as a mapping load and once as a normal load? If not, can you provide an example with full syntax to show how I could calculate a field in the script without using mapping loads?