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


Please Help Members By Posting Answers For Below Questions

how can we create rank using datastage?what is the meaning of rank?

8444


What are the steps required to kill the job in Datastage?

940


Explain ibm infosphere information server and highlight its main features?

841


What is the difference between in process and inter process?

898


How to reverse the string using SQL?

1127


What is orabulk stage?

828


Differentiate between odbc and drs stage?

809


What is the difference between hashfile and sequential file?

939


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2026


How to read multiple files using a single datastage job if files have the same metadata?

986


Can you implement SCD2 using join, transformer and funnel stage?

1310


Explain connectivity between datastage with datasources?

780


EXPLAIN SCD

1158


What are the various kinds of containers available in datastage?

791


which r the connectors used in san?

1977