You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » suggestion - tLookup & tStoredProc
#1 2006-11-09 18:24:30
- hugo
- Guest
suggestion - tLookup & tStoredProc
A Lookup component would be useful - allow you to lookup values in databases. Essentially it would allow you to perform joins and output specified fields as part of the mapping.
tStoredProc would also be very nice - allowing you to execute stored procedures in the mapping (and of course pass values into the sp and get values out and use the results in the mapping)
#2 2006-11-09 19:06:12
- fbonan
- Talend team
- Registered: 2006-10-02
- Posts: 53
Re: suggestion - tLookup & tStoredProc
(re) Hi Hugo!
About join:
In fact, our tMap component can perform (left/right) join and multiple join (with or without on-the-fly transformation)!
We made a tutorial : "How to take advantage of the tMap component".
This tutorials address folowing topics :
- Map Editor
- Metadata Editor
- Set up a Join (here it is!)
- Multiple Constraints
- Reject Output
- Var Expressions
- Multiple Outputs
Regards,
Fabrice
Offline
#3 2006-11-10 16:49:33
Re: suggestion - tLookup & tStoredProc
hugo wrote:
tStoredProc would also be very nice - allowing you to execute stored procedures in the mapping (and of course pass values into the sp and get values out and use the results in the mapping)
You can use tDBInput or tDBSQLRow to execute a stored procedure. Did you try these components? don't they suit your need?
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » suggestion - tLookup & tStoredProc