Interested to Buy Any Domain ? << Click Here >> for more details...
I have scenario like this seq file --> transformer --> sort
stage --> dataset
In this job which prtitioning technique you are using and
why???
- 3 Answers
- 21976 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kiran
Hash partition or modulus partition. When using sort
operations always better to go for key partition techniques.
| Is This Answer Correct ? | 40 Yes | 4 No |
Answer / ashok
we want write partition on integer type field like deptno
then go to modulus other wise go to hash is better in
performance wise
| Is This Answer Correct ? | 12 Yes | 5 No |
Answer / bharath
Hash or Modulus partitioning
better go for hash becoz based on keyed partitioning is
best for the sort...
| Is This Answer Correct ? | 5 Yes | 1 No |
How can you find out whether datastage process is running or not in unix?
I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?
How to create a doccument in datastage?
Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x
What is the purpose of pivot stage and types of containers in datastage
What is Fastly Changing Dimension?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
what is main difference between change capture and change apply stages
how to sort two columns in single job in datastage.
what is parameterset?
why do u need the IOS upgradation in a FC switch
Teradata 
