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 / 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 |
what is the use of surogate key in datastage
How complex jobs are implemented in datstage to improve performance?
How to Remove Duplicate using SQL?
how do you pass parameters in a script?
Which algorithm you used for your hashfile?
how to load meta data
where we use column generator stage in real time scenario?
How the ipc stage work?
Two source files contains same meta data third file contains different data types can I funnel that file.
Is it possible to query a hash file?
explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT
What is ibm datastage?