what is Partitioning ? where we can use Partition?
- 2 Answers
- 22508 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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 the internal processes of integration server in Informatica? How data will be extract and load to the target?
what is mapping parameter?
How to eliminate duplicates from flat file..what is the procedure
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
What is Performance tuning in Informatica?
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
tell me the push down optimization
how can one come to know wether the records loak into the target if we use update strategy
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
Design time, run time. If you don't create parameter what will happen
Teradata 
