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 importance of the exception activity in datastage?
How do you schedule or monitoring the job?
wt is the diff b/w odbc and oracle stage
How can we improve the performance in datastage?
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
difference between function and procedure...
how to change left and right links in join stage?
table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?
job locking methods? How can we unlock the job?
What is the difference between Datastage 7.5 and 7.0?
how to sort two columns in single job in datastage.
What is RCP