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 |
source file contains 100 records, i want 10 records in target file how it possible in datastage
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
In Datastage, how you can fix the truncated data error?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?
input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?
Explain the functionality of your current project?
1 Answers IBM, Miles Software,
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
What are the primary usages of datastage tool?
Differentiate between datastage and informatica?
what is the main differences between Lookup, Join and Merge stages?
What is ds designer?