Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to create a flag in the script, the scenario is Sample company has subscriptions for customers, inventory, customer emails and in addition, employees can buy a subscription as well. So the flag I am trying to create is where subscription belongs to an employee then Yes else No. The join or lookup will be customer email to employee email.
I prefer not to use mapping load to keep the optimized load in load script and also I have to convert the email fields to Upper() as they are inconsistency with regards to email alphabet characters.
Thanks in advance.