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

can any one give some examples for pre sql and post sql(Except dropping and creating index).

3490


Can we create a node as a gateway node and the same node can be assigned to a grid?

626


generate date / time dimension in informatica

705


How to generate sequence numbers using expression transformation?

624


How union transformation is used?

579






What are the advantages of informatica?

560


How to do unit testing in informatica?

704


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2414


What is a stored procedure transformation?

599


list out all the transformations which use cache?

675


What is sorter transformation?

570


How to start a workflow using pmcmd command?

697


How to generate sequence numbers?

606


Where do we use mapping variables in informatica?

602


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

542