What is the diff between sort performed at sort stage and
the stream sort performed at the input of few stages in DS
Enterprise edition?
Answer Posted / pooja
Sort Stage
__________________________________________________________
1. Complex Sorts
2. When explicit Sorting Stage is required.
3. When Key change or cluster Key change columns are
required. As based on it the data needs to be filtered out
ahead in the job.
Sort performed in the input of few stages or Insort Stage
__________________________________________________________
1. Simple Sort
2. When there is no need to define a Sort stage explicitly.
3. There's no such option as key change here.
need to use
stage explicitly.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the precedence of stage variables,derivations, and constraints?
What are the components of datastage?
How to manage date conversion in Datastage?
Difference between server jobs & parallel jobs?
What is a quality stage in datastage tool?
how to abort the job its matain duplicates?
How to perform incremental load in datastage?
What is datastage engine?
What is the use of datastage designer?
CHANGE CAPTURE
What is the difference between server job and parallel jobs?
Describe routines in datastage? Enlist various types of routines.
How many types of hash files are there?
Define oconv () and iconv () functions in datastage?
What is usage analysis in datastage?