1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / jayaram.k

Answers were Sorted based on User's Feedback



I have scenario like this seq file --> transformer --> sort stage --> dataset In this j..

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

I have scenario like this seq file --> transformer --> sort stage --> dataset In this j..

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

I have scenario like this seq file --> transformer --> sort stage --> dataset In this j..

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

Post New Answer

More Data Stage Interview Questions

how to handle null values in sequential file?

1 Answers   HCL,

how to write server Routine coding?

0 Answers   Eric,

Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain

2 Answers  

How to remove blank spaces from data?

3 Answers  

how to unlock a locked job in datastage 8.0

3 Answers   HCL,




How to Remove Duplicate using SQL?

0 Answers   CTS,

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 Answers   TCS,

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls

7 Answers   TCS,

What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,

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

3 Answers   Polaris,

hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

1 Answers   Wipro,

Which type of joins Merge stage can support?

7 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories