I have scenario like this seq file --> transformer --> sort
stage --> dataset
In this job which prtitioning technique you are using and
why???
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 |
can any one tell me how to install datastage 8.1 in windows xp with wizard
how can or from where we can get reference data in scd type2 implementation?
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
what is factless fact table?
What is datastage?
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
How many types of sorting methods are available in datastage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
I am getting input value like X = Iconv(ā31 DEC 1967ā,āDā)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().
how can we create rank using datastage?what is the meaning of rank?