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 |
How do u call shellscript/Batch file from DS?
what is the use of materialized view?
How to find value from a column in a dataset?
what is the main difference between sorragate key n primary key in one word
what is the diff b/w switch and filter stage in datastage
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
how can we create a Sorrogate key in transformer stage? I want it in parallel mode
What are the features of datastage flow designer?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
How to generate surrogate key without using surrogate key stage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What is the difference between the local container and shared container?