Why We Use Partitioning The Session In Informatica?

1.	Why We Use Partitioning The Session In Informatica?
Answer» Performance can be improved by processing data in PARALLEL in a single SESSION by creating multiple PARTITIONS of the pipeline. INFORMATICA server can achieve HIGH performance by partitioning the pipeline and performing the extract , transformation, and load for each partition in parallel. Performance can be improved by processing data in parallel in a single session by creating multiple partitions of the pipeline. Informatica server can achieve high performance by partitioning the pipeline and performing the extract , transformation, and load for each partition in parallel.

Answer»

Performance can be improved by processing data in PARALLEL in a single SESSION by creating multiple PARTITIONS of the pipeline.

INFORMATICA server can achieve HIGH performance by partitioning the pipeline and performing the extract , transformation, and load for each partition in parallel.

Performance can be improved by processing data in parallel in a single session by creating multiple partitions of the pipeline.

Informatica server can achieve high performance by partitioning the pipeline and performing the extract , transformation, and load for each partition in parallel.

Discussion

No Comment Found

Related InterviewSolutions

When We Create A Target As Flat File And Source As Oracle. How Can I Specify First Rows As Column Names In Flat Files?
What Is Meant By Direct And Indirect Loading Options In Sessions?
What Is Difference Between Informatica 7.1 And Abinitio?
How To Join Two Tables Without Using The Joiner Transformation?
Difference Between Static And Dynamic Cache And Explain With One Example?
How The Informatica Server Sorts The String Values In Ranktransformation?
What Is Data Merging, Data Cleansing, Sampling?
What Are The Unsupported Repository Objects For A Mapplet?
Discuss Which Is Better Among Incremental Load, Normal Load And Bulk Load.
What Is Update Strategy Transformation ?