Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Mo_labib25
Contributor
Contributor

Dynamic migration of oracle tables between different schemas

Hello there

currently i am making a talend job to dynamically migrate the data of tables from HR schema in oracle db to anotother schema

i am using Talend open studio for data integration the problem i face related to the schema of the data in the output. here is the job i desinged

0695b00000lyPrNAAU.png

here is the problem , the data in target has only one col (dynamic_field) and all the data for each row in this col i don't know how can i handle the dynamic schema for each table as this feature is not in talend open studio , is there any idea that can help me

0695b00000lyPtYAAU.png

Labels (4)
3 Replies
Mo_labib25
Contributor
Contributor
Author

the details for TjavaRow_1

0695b00000lyQ5PAAU.png 

0695b00000lyQ4WAAU.png

Mo_labib25
Contributor
Contributor
Author

the details for tDBinput_2

0695b00000lyQ8sAAE.png 

0695b00000lyQ84AAE.png

Mo_labib25
Contributor
Contributor
Author

the details for tAggergateRow_1

 

0695b00000lyQAAAA2.png