what is the differeces between hash and modulus partition
methods

Answer Posted / kiran

hai this is Kiran..,

If the key field is numeric use modules else hash
partition.as per performance tuning.

Is This Answer Correct ?    16 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1199


what is the use of materialized view?

1226


How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2332


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3457


sed,awk,head

1229


How will you move hashed file from one location to another location?

1911


How do u convert the columns to rows in datastage?

920


In Datastage, how you can fix the truncated data error?

879


How to perform incremental load in datastage?

931


Difference between ‘validated ok’ and ‘compiled’ in data stage?

933


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

2045


Explain connectivity between datastage with datasources?

797


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

1335


What is the flow of loading data into fact & dimensional tables?

840


if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

1963