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 is the difference between odbc and drs stage?
What are the repository tables in datastage?
Differentiate between operational datastage (ods) and data warehouse?
how do u catch bad rows from OCI stage? And what CLI stands for?
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
Define orabulk and bcp stages?
What are the main differences you have observed between 7.x and 8.x version of datastage?
what is the use of materialized view?
Nls stands for what in datastage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Explain usage analysis in datastage?
What are the difference types of stages?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Does datastage support slowly changing dimensions ?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance