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 |
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
COM components can be used in Informatica
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
Useful UNIX commands regular/frequently used
when we dont use aggregator in mapping ?
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
Differentiate between a database and data warehouse?
what is the size of u r source(like file or table)?
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
What is predefined event?
Difference between session variables and workflow variables?