I have scenario like this seq file --> transformer --> sort
stage --> dataset
In this job which prtitioning technique you are using and
why???
Answer Posted / 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 |
Post New Answer View All Answers
How can one find bugs in job sequence?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is size of a transaction and an array means in a datastage?
What are the types of hashed files in data stage
how to add a new records into source?
What are the stages in datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
What are routines in datastage? Enlist various types of routines.
Explain connectivity between datastage with datasources?
What is a merge?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How you Implemented SCD Type 1 & Type 2 in your project?
What is the difference between Datastage 7.5 and 7.0?
Name the command line functions to import and export the DS jobs?
What is the method of removing duplicates, without the remove duplicate stage?