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
how to sort two columns in single job in datastage.
What is the difference between passive stage and active stage?
What is ibm datastage flow designer?
How do you generate sequence number in datastage?
What are the different layers in the information server architecture?
why do u need the IOS upgradation in a FC switch
Explain datastage architecture?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are some different alternative commands associated with "dsjob"?
Explain how a source file is populated?
What are the partitioning techniques available in link partitioner?
How many types of views are there in a datastage director?
how to abort the job its matain duplicates?
What a datastage macro?
what is the custome stage in datastage? how can we impliment that one? plz tell me