You are not logged in.
Thanks for the answer. It helped.
You use a view in the same way as using a table - nothing different.
You can put your complex query in tOracleInput and guess the schema from it or read each table and do a lookup in a tMap for he joins.
I am having problems while populating a data set from mutiple tables. I cannot do it with multiple toracleinput components here for my scenario as the query is going to be very complex. Is there anyway, we could do this by calling a view , if so how can we use views in talend. ( usage of Stored Proc is not permitted).
I need to call 2 tables in a toracleinput or by any other component.
select * from TAB1 join Tab2 on TAB1.a=TAB2.a
Finally My Q's are -1 ) how can we use a query with mutiple tables
2) How to use a Oracle view in Talend.