Interested to Buy Any Domain ? << Click Here >> for more details...
what is Partitioning ? where we can use Partition?
- 2 Answers
- 23332 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 |
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
Performance wise which is better joiner or look up ? Give me with example?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
plz plz plz send client names and project names in informatica?
explain about informatica server architecture?
what r the transformations that r not involved in mapplet?
how do u fnd the duplicate rows and how to delete the duplicate rows?
Enlist few areas or real-time situations where informatica is required.
What is the use of transformation?
Where are the source flat files kept before running the session?
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
Teradata 
