Interested to Buy Any Domain ? << Click Here >> for more details...
How to call stored procedure and function in talend job
- 1 Answers
- 7 Views
- I also Faced
- E-Mail Answers
Answer / Gaurav Singh Sengar
To call a stored procedure or function in a Talend job, you can use the tSQLRow component. Here's how:n1. Add a tSQLRow component to your job design.n2. Configure the connection parameters (database type, host, port, username, and password).n3. In the 'Query' field, write the call to the stored procedure or function. For example: `CALL myProcedure(?)` or `SELECT myFunction()`. Replace 'myProcedure' and 'myFunction' with your stored procedure or function names.n4. Set the input parameter if required (using the 'Input Parameters' tab).n5. Preview the data to verify the call.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the default date pattern in talend?
Is it possible to call web services from talend job?
What do you mean by tjoin?
What is Code Generator in Talend?
What does expression editor do in talend?
What is the difference between the etl and elt components of talend open studio?
What’s a “insert or update” and “update or insert”, how do we find the difference?
What is the importance of tLoqateAddressRow component in Talend?
How data can be sent from the parent job to the child job?
What is tunite in talend open studio
Difference between etl and elt components in talend?
Talend is written in which language?
Microsoft Azure 
