Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Simple tMap Oracle input - Oracle output example?

Hi,
I have one table in one Oracle schema and a second table in a second Oracle schema. As a first try, I want to map fields on the first table into the second one. I have used tOracleInput, tMap and tOracleOutput to do so. Right clicking tOracleInput I have drag and drop it in the tMap component. Up to here, everything fine. When I try to drag and drop from tMap, to the OracleOutput component, it tells me that the input is invalid. It doesn't take the output schema so I have to re-type all the output columns to give them the correct name (it repeats the input field names in the output part).
How could I do this mapping? Any video available?
Thanks in advance
Labels (2)
3 Replies
Anonymous
Not applicable
Author

Hi  spr655,
 What's the build version you are using? Could you please give us more detailed steps to repro your issue and show us your current job design screenshot?
Best regards
Sabrina
Anonymous
Not applicable
Author

Dear Sabrina,
I have created an tOracleInput, then configured it to access the table database. Then, I have created a tOracleOutput, with the necessary parameters to access the table in the database. As third element, I have integrated a tMap component in between the elements. This tMap did contain the correct column names of the tOracleInput table, but in the right side, it contained the same column names, not the ones from the tOracleOutput table.
I am using Talend Open Studio  V5.6.2_20150508_1414.
Thanks in advance.
0683p000009MB0n.png
_AnonymousUser
Specialist III
Specialist III

In Output give another schema credentials properly..