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 |
Can you highlight the main features of ibm infosphere information server?
Explain Quality stage?
What is the difference between hashfile and sequential file?
I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help
What are the various kinds of the hash file?
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me
where we use column generator stage in real time scenario?
1.what is materialized data? 2.how to view the materialized data?
How to use Environment variable's in datastage?(use of process)
Explain usage analysis in datastage?
Which warehouse using in your datawarehouse