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:32
Post Edited by rumbi at 02/07/2012 17:35
Post Edited by rumbi at 02/07/2012 17:35
1 Answer:
Posted on July 3, 2012 at 2:49am
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
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
