I have scenario like this seq file --> transformer --> sort
stage --> dataset
In this job which prtitioning technique you are using and
why???

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in oracle target stage when we use load option and when we use upsert option?

1759


Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2440


Difference between in process and inter process?

704


What are the main features of datastage?

668


What is difference between join, merge and lookup stage?

642






What is a quality stage in datastage tool?

634


What are the different types of lookups in datastage?

634


what is the custome stage in datastage? how can we impliment that one? plz tell me

1915


What is datastage?

652


What are the functionalities of link collector?

630


How to manage date conversion in Datastage?

644


Difference between data warehousing and olap?

655


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

1672


Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

356


Explain Quality stage?

673