Answer Posted / 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 |
Post New Answer View All Answers
Explain what are the different types of transformation available in informatica.
How would you join a node to the already existing domain?
What are the tasks that source qualifier perform?
What all join we can perform in LOOKUP transformation?
What is dynamic cache?
Briefly explain the aggregator transformation?
Describe an informatica powercenter?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is the Rank index port in Rank transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is Index Caches size?
explain one complex mapping with logic? sales project?
How to extract sap data using informatica?
According to his methodology what all you need before you build a datawarehouse
What is different between the data warehouse and data mart?