Will datastage do the necessary transformation row by row if I use Oracle custom function passing rowid as a parameter to the oracle custom function to excute complex sql query?I am intending to call the function
as a userdefined function from the Oracle Enterprise stage.
Custom oracle function to do execute complex sql transformat
Moderators: chulett, rschirm, roy
"Will datastage do the necessary transformation"
What does that mean?
If you use a user-defined function in a SQL select query DS doesn't know or care. If your function is "doing stuff" such as queries than understand the performance impact that each row in the query set will run that function, which means that Oracle is unable to optimize the entire query.
Please clarify with a specific explanation of what you are doing.
What does that mean?
If you use a user-defined function in a SQL select query DS doesn't know or care. If your function is "doing stuff" such as queries than understand the performance impact that each row in the query set will run that function, which means that Oracle is unable to optimize the entire query.
Please clarify with a specific explanation of what you are doing.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle