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
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
what is the use of materialized view?
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?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
sed,awk,head
How will you move hashed file from one location to another location?
How do u convert the columns to rows in datastage?
In Datastage, how you can fix the truncated data error?
How to perform incremental load in datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
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
Explain connectivity between datastage with datasources?
Can you implement SCD2 using join, transformer and funnel stage?
What is the flow of loading data into fact & dimensional tables?
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?