Answer Posted / rajesh.dwh
Function must returns value, but Procedure may or may not
return value.
Function can be use with select statement where Procedure
can't be used with select statement regarding ORACLE SELECT
statement.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is active and passive stage?
What is the difference between the local container and shared container?
How many areas for files does datastage have?
Explain the situation where you have applied SCD in your project?
What is aggtorec restructure operator?
Difference between in process and inter process?
What are system variables and sequencers in datastage
Nls stands for what in datastage?
How do you register plug-ins?
What is the roundrobin collector?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
How do you schedule or monitoring the job?
Triggers,VIEW,Procedures
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do