You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » Usage of view for multiple table
Post a reply
Topic review (newest first)
- psreepa
- 2012-04-09 04:15:07
Thanks for the answer. It helped.
- janhess
- 2012-04-03 10:35:28
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.
- psreepa
- 2012-04-03 01:26:45
Hello,
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.
eg:
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.
Thanks
psreepa