I have a Firebird database with about 200 different views. Some views are very very slow... I need to create tables with the same scheme and all data from the views.
So I created a test-job (tFirebirdInput -> tMap -> tFirebirdOutput) with the scheme of one view. To update my "view-table" I start a batch task for my job. Now my problem:
What is the easiest\fastest way to create jobs for all my views? The views contain different columns and I create new views every week\month, so I can't copy and change my test-job manually every time.
Can I create jobs via batch file and params to get something like "Connect to Firebird DB -> get View_Name_XY -> create Table with same scheme like view XY -> auto-map all colums -> copy all data from view to table"?
Or do I have to create all jobs manually in Talend Open Studio? Thanks in advance!
Solved! Go to Solution.