Stage Variables and Constants
Describe the term Derivations, Stage Variables and Constants?
Expert
a) Derivation - Expression which specifies value that can be passed on to the target column.
b) Stage Variable – It is defined as an intermediate processing variable which retains the value during read and does not pass the value to the target column.
c) Constant - Conditions that are either true or false which specifies that flow of the data along with a link.
What understand by the term SQL, and give its importance?
Describe briefly the term Session and Batches?
Illustrates the applications of ASA?
Specify some of the different @ Functions?
Describe briefly the difference between pessimistic locking and optimistic locking?
Explain the way of transactions in Sybase. How it relates with partition assignment.
Write a short note on the differences between vertical and horizontal portioning?
Provide a brief introduction of the term ‘junk dimension’?
Explain the advantage of Table Partitioning with bcp in Sybase?
Illustrates the quickest sorting method to use?
18,76,764
1934611 Asked
3,689
Active Tutors
1447296
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!