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 datastage designer?
what is the difference between datasatge and datastage TX?
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
How a source file is populated?
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage
how do u capture duplicates through sort & transformer
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
Describe the architecture of datastage?
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?