I have scenario like this seq file --> transformer --> sort
stage --> dataset
In this job which prtitioning technique you are using and
why???
- 3 Answers
- 21556 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 |
if ename='subbu' while running job the job should be abort how come?
Difference between server jobs & parallel jobs?
why we use hash file for lookup?
What is the default padding character?
how to write server Routine coding?
How you can fix the truncated data error in datastage?
what are the errors,warnings in datastage
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
Which algorithm you used for your hashfile?
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls
Why we need datasets ratherthan sequential files?
How and where you used hash file?
Teradata 
