rumbi Posted February 6, 2012 Share Posted February 6, 2012 I have to extract 28 tables from MS SQL Server 2000 using jaspersoft etl, transfrom them and load them onto a Mysql database. The question is:Does this mean creating 28 jobs? This I know how to do.Or can I extract them in one job? If so how? Post Edited by rumbi at 02/07/2012 17:32Post Edited by rumbi at 02/07/2012 17:35Post Edited by rumbi at 02/07/2012 17:35 Link to comment Share on other sites More sharing options...
agharti81 Posted July 3, 2012 Share Posted July 3, 2012 Hi Rumbi What kind of transformation you need to perform? of course you can do everything (probably) in just 1 job, but this can raise problems in performances, memory and so on.If it's just a migration (copy 1 table into another in another dbms) it's easy and you can do as you prefer, but if you need to join tables you need a better design. Mauro Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now