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?
- 1 Answers
- 9211 Views
- I also Faced
- E-Mail Answers
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 Cleanup Resources and when do you use it?
What is RCP?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
how to capture rejected data by using join stage not for lookup stage. please let me know
What is the difference between operational data stage (ods) and data warehouse?
Can we use Round Robin for aggregator?is there any benefit underlying?
Can we use target hash file as a lookup ?
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
What is mapping?
what is the differeces between hash and modulus partition methods
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
Teradata 
