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 do you create single lookup transformation using multiple tables?
What is an incremental loading? in which situations we will use incremental loading
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Do you have to change the reject file b4 using reject loader utility.
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
how to move the mappings from your local machine to claint place?
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
how can u load the data in time dimension?
What are the Differences between connected and unconnected lookup?