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 the components of datastage?
How complex jobs are implemented in datstage to improve performance?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Why we use surrogate key?
What are orabulk and bcp stages?
Name the different sorting methods in datastage.
To see hidden files in LINIX?
What are the types of jobs we have in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Explain ibm infosphere information server and highlight its main features?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Highlight the main features of datastage?
What are the types of containers in datastage?
Can you explain tagbatch restructure operator?