Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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