i have been asked to do the follwoing and not sure the best way to go about it.
all broker account are 11130. when the data runs trough the ssis package its going to roll up account on fundcode and account identifier. so i need to do something to show that bank of new yourk and jp morgans are different by adding something to the account identifier coulmns. like 11130a and 1130b or a even another number. any ideas the best way to go about this.
also going forward they will probably be different ones with new code