Interested to Buy Any Domain ? << Click Here >> for more details...
What is hash partition?
- 1 Answers
- 8130 Views
- I also Faced
- E-Mail Answers
Answer / bhanu pratap
Hash partitioning:-
use hash partitioning , when we want the power center server
to distribute rows to the partitions by groups.
Eg :- we need to sort items by item ID , but we don't know
how many many items have a particular ID mamber
| Is This Answer Correct ? | 6 Yes | 1 No |
What is the benefit of session partitioning?
What is the need of etl tools?
Explain the types of transformations?
When you move from devel to prod how will you retain a variable
How to retrieve last two days updated records?
Can you start a session inside a batch individually?
What is the difference between router and filter?
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
How to Create a folder using pmrep command?
Differentiate between a repository server and a powerhouse?
 Code page compatibly –Where all changes are made to handle the scenario.
Explain the flow of data in Iinformatica?
Teradata 
