what is Partitioning ? where we can use Partition?
Answers were Sorted based on User's Feedback
Answer / mahesh
The Partitioning Option increases Power Center?s
performance through parallel data processing, and this
option provides a thread-based architecture and automatic
data partitioning that optimizes parallel processing on
multiprocessor and grid-based hardware environments.
Partitions are used to optimize the session performance. We
can select in session properties for partitions
Types- Default----pass through partition, key range
partition, round robin partition, hash partition.
| Is This Answer Correct ? | 28 Yes | 5 No |
Answer / annu
Partitioning is a utility provided by informatica which
evolves nature of parallel processing on a grid or
multiprocessor database architecture. Partition means
a "thread of ETL data load in chunks". Like Unix, Multiple
data load thead will be executed parallely and sync up the
result set to one instance of Target.
For more detail of using Informatica Partitioning with
visual graphs
visit : http://informatica-tech-talk.blogspot.com/
| Is This Answer Correct ? | 4 Yes | 0 No |
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
How does a rank transform differ from aggregator transform functions max and min?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
What is the difference between informatics 7x and 8x and what is latest version?
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
what is the necessity to use update strategy?(except for updates)
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
If we have lookup table in workflow how do you trouble shhot to increase performance?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is aggregate cache in aggregator transforamtion?
what happens if you try to create a shortcut to a non- shared folder?