Hi As ETL tool, Talend Data Integration supports transformation within different datasources. Use tOracleInput and tDB2Output components. Edit Schema of each component with the same types and fields. Regards, Pedro
Hi Pedro, Thanks for the fast reply. I see the idea, anyway i am not able to guess the input schema. Nothing happens, or i need to add the input columns manually?
Hi What do you mean "i am not able to guess the input schema"? Have you created metadata->Db Connections? If so, you can retrieve schema from metadata. Or you encounter a bug? Regards, Pedro
Hi Pedro,
Apparently column descriptions from DB2 where not imported to Oracle. I can see them on Output Schema (Talend view) but when looking the Oracle table the column comments are all (null). What i am missing? Thanks.
Hi Joel I received your email. Sorry for my delay to answer. There must be something wrong with tOracleOutput settings. Could you upload the screenshot of tOracleOutput? Regards, Pedro
Hi Joel
I see your image and find that you didn't set attributes "Database" and "Oracle Schema".
One more thing, you'd better select "Create table if not exists" this time.
I strongly recommend you read Tutorials about TOS and download the document.
Regards,
Pedro
Hi Pedro, I did what you suggested but comments are still null. Any other suggestion? I tried MySQL instead Oracle and same happens. I am using Talend Open Studio 4.1.2. About documentation, could you provide any link where i can download it? Thanks.
