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 |
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
How to reverse the string using SQL?
What is the precedence of stage variables,derivations, and constraints?
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
explain about citrix scheduling tool in datastage
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A
Explain usage analysis in datastage?
What is ibm datastage?
Can you define merge?