Hi,
what is use of Macros,functions and Routines..?
At what situation you are used.
If you know the answer please explain it.
Thanks.
- 1 Answers
- 2145 Views
- I also Faced
- E-Mail Answers
Answer / Vineeta Gunjiyal
Macros, functions, and routines are tools used in programming to simplify repetitive tasks, reduce errors, and improve efficiency. Macros are predefined sequences of commands stored for later execution, while functions and routines can accept parameters, perform calculations or operations, and return results.nThey are useful in a variety of situations, such as automating repetitive tasks, performing complex calculations, managing data validation, and implementing custom logic.
| Is This Answer Correct ? | 0 Yes | 0 No |
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
On which interface you will be working as a developer?
I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
Explain the ChangeApply stage?
How to move data set from one server to other?what are the steps to follow to do this?
Describe stream connector?
Name the command line functions to import and export the DS jobs?
What are orabulk and bcp stages?
What is the use of Row generator stage?
Define Merge?
Can you explain engine tier in information server?
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?
Teradata 
