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
- 22004 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 |
What are stage variables and constants?
What is a quality stage in datastage tool?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
how do u catch bad rows from OCI stage? And what CLI stands for?
How to create environments and call them? What is the use defined variables?
Difference between sequential file and data set?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is "fatal error/rdbms code 3996" error?
What is the use of hoursfromtime() function in transformer stage in datastage?
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran
Teradata 
