Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
..
convert the history data customer number to new db customer number
the history data doesn't change, you should only convert only once the old number to new number
How can i do it?
In scrip or as a query? do i need to do it for all the customers ?
we have 10000 customers. and what keywords should i use?
in script as the old system doesn't change (I think)
for all customers
you need a conversion (mapping, decode) table from the old code to the new one or some other field (customer name?) to drive the conversion
This can be done in qlikview or SQL??
Also I dint understand your approach properly please help.
Create a history in QVD's or copy the data from DB1 and DB2 into the NEW DB and at the same time converting old customer numbers into their corresponding new customer numbers.