ODI 12c Tutorials Lession10 ODI 12c Procedure with Options example

[@bh_11x]

Thank you so so much!!!

[@kenghuatan5414]

Thanks for the tutorial!

[@saktishee3710]

Awesome, very good depth knowledge. Can you please tell how to copy all the datastores from one model to another at once ???

[@singamsanjay3934]

Can we use SQL query as source in ODI.?

[@PoojaDasputu]

I want to create a procedure. By default my procedure is using ftiodistage user to get the values. Not this user is moved to different database altogether. I want to change my user to run this procedure. How to do that ?

[@moesmael]

How to use varibles in Procedures. For example select CUL1,cul2 into #Var1,#var2 from X where Var_date between #Vdate1 and #var_date2

[@raulmorenobello7202]

1) Create an Option of type Value for each var. The vars will pass to the Procedure through these Options. 2) in the procedure code use (notice the double quotes) each time you want to use that variable. 3) In the Package where you call the Procedure, go to the Options tab and call the variable for each Option (#ProjectName.VarName). In case you want to run the procedure by itself (testing...), you can set the "Direct Execution Value" for each variable.

[@raulmorenobello7202]

In fact, it seems you can also just write the variables #ProjectName.Varname in the code if they are alphanumeric and ODI will substitute them; remember to enclose them between quotes if they will act as strings in the code.