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 |
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Why we use ENABLE HIGH PRECISION in session properties?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
What is joiner cache?
What is a repository? And how to add it in an informatica client?
Is LOAD MANAGER AND LOAD BALANCER same in informatica?
What is difference between a connected look up and unconnected look up?
how tokens will generate?
How to join three sources using joiner?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
How do you take care of security using a repository manager