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?



What is the diff between sort performed at sort stage and the stream sort performed at the input o..

Answer / 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

More Data Stage Interview Questions

i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 Answers  


How to reverse the string using SQL?

0 Answers   CTS,


What is the precedence of stage variables,derivations, and constraints?

0 Answers  


What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

0 Answers   TCS,


explain about citrix scheduling tool in datastage

0 Answers   HSBC,


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

0 Answers   IBM,


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

0 Answers   ABC, TCS,


I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A

3 Answers   IBM,


Explain usage analysis in datastage?

0 Answers  


What is ibm datastage?

0 Answers  


Can you define merge?

0 Answers  


Categories