what is Partitioning ? where we can use Partition?
Answer Posted / 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 |
Post New Answer View All Answers
In informatica workflow manager, how many repositories can be created?
What are the types of presistent cache in look up tr.
What is a passive transformation?
Explain the mapping variable usage example in informatica
How do you promote a non-reusable transformation to reusable transformation?
Write the prerequisite tasks to achieve the session partition?
What is the sql query overwrite in source qualifier in informatica
How to create the list file having millions of flat files while indirect loading in informatica? 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 is union transformation utilized?
Which files are created during the session rums by informatics server?
According to his methodology what all you need before you build a datawarehouse
How to load a Dimension ? and how to load a fact table?
In warehouses how many schemas are there?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Write the different tools in the workflow manager?