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 |
WHAT IS FACT TABLES?
what is unique constraint error ?
What is a command that used to run a batch?
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
What are the methods for creating reusable transforamtions?
What are multi-group transformations?
what is target update override and when we use it?
what is target load plan
How do you remove duplicate records in informatica?
Do you have knowledge in ralph kimball methodology
What is deployment group?
How Union Transformation is an Active Trans?