How the informatica server increases the session performance
through partitioning the source?



How the informatica server increases the session performance through partitioning the source?..

Answer / swetha

For a relational sources informatica server creates multiple
connections for each parttion of a single source and
extracts seperate range of data for each connection.
Informatica server reads multiple partitions of a single
source concurently. Similarly for loading also informatica
server creates multiple connections to the target and loads
partitions of data concurently.

For XML and file sources,informatica server reads multiple
files concurently. For loading the data informatica server
creates a seperate file for each partition(of a source
file).U can choose to merge the targets.

Is This Answer Correct ?    7 Yes 0 No

Post New Answer

More Informatica Interview Questions

WHAT IS FACT TABLES?

2 Answers  


what is unique constraint error ?

2 Answers   TCS,


What is a command that used to run a batch?

2 Answers  


Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

10 Answers   CSC,


What are the methods for creating reusable transforamtions?

2 Answers  






What are multi-group transformations?

0 Answers   Informatica,


what is target update override and when we use it?

2 Answers   TCS,


what is target load plan

2 Answers   Cap Gemini,


How do you remove duplicate records in informatica?

1 Answers  


Do you have knowledge in ralph kimball methodology

1 Answers  


What is deployment group?

0 Answers  


How Union Transformation is an Active Trans?

6 Answers  


Categories