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


Please Help Members By Posting Answers For Below Questions

How many types of sessions are there in informatica.please explain them?

678


What are the performance considerations when working with aggregator transformation?

678


How many dimensions are there in informatica?

630


What is a filter transformation?

571


Explain about Informatica server process that how it works relates to mapping variables?

624






What is InformaticaPowerCenter?

692


what is size of u r database?

1850


Does an informatica transformation support only aggregate expressions?

608


complex mapping ur project u r invlve can u explain and give real time example give me ?

1845


Why do we need informatica?

554


How can you generate reports in informatica?

581


How do you load alternate records into different tables through mapping flow?

1298


What is a snowflake schema?

573


Explain joiner transformation in informatica

668


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

636