difference between function and procedure...
Answer / 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 |
Differentiate between odbc and drs stage?
Difference between JOIN,LOOKUP,MERGE?
Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3
1 Answers Alpharithm Technologies,
How can we improve the performance in datastage?
how to sort two columns in single job in datastage.
What is staging variable?
Explain the scenarios where sequential file stage runs in parallel?
Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
what is the best stage in datastage parller jobs to use full out join and why
What is the precedence of stage variables,derivations, and constraints?