karthiknfr_1991 (10/14/2016)
We have access etl running on server A and B. We are going to decommission server A . There is another as400 server where we run lansa queries to fetch the data for etl and load it in to database. Now everything starting from lansa to access have to be rewritten in sql server
First step is to document those processes and any logic within those such as transformations, lookups etc.. Next is to map each logical unit to the best fit destination within the new architecture, i.e. sorting and lookup on SQL Server, file manipulation within SSIS etc. and after that is done then first do you start designing and PoC coding the new processes.
😎