How the informatica server increases the session performance
through partitioning the source?
Answer Posted / 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 View All Answers
What is the Rank index port in Rank transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is workflow? What are the components of workflow manager?
What is mapplet in informatica?
What are the reusable transformations?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Explain load alternative records / rows into multiple targets - informatica
Parameter and variable differences
design of staging area?
what are 3 tech challenges/ common issues you face?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is the difference between a connected look up and unconnected lookup?
What is the advantage of informatica?
What is a repository manager?