load huge data from very big query with multiple joins(used to create view) to a table in database
hi,
I Need to replace a view to a table. so in the database I created a new table with columns used in the select statement of the view. Then in the talend job I have used one tdbinput component and copied the select statement from the view and pasted. . next I have created a tdboutput component and linked it with my input component.
the job is taking 2 hours to execute and finally stops. not loading the data..
My job has below components.
Tdbinput---->Tdboutput
what other approach i can use here to load data to the target table?
