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
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Can we create a node as a gateway node and the same node can be assigned to a grid?
generate date / time dimension in informatica
How to generate sequence numbers using expression transformation?
How union transformation is used?
What are the advantages of informatica?
How to do unit testing in informatica?
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?
What is a stored procedure transformation?
list out all the transformations which use cache?
What is sorter transformation?
How to start a workflow using pmcmd command?
How to generate sequence numbers?
Where do we use mapping variables in informatica?
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?