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 event and what are the tasks related to it?
What is target load order?
Difference between Data and Index Caches?
How are the sources and targets definitions imported in informatica designer?
How to generate sequence numbers using expression transformation?
tell me the rules and responsblites in our project(my project is development)
Design a mapping to load the cumulative sum of salaries of employees into target table?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
how tokens will generate?
How to elaborate powercenter integration service?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is exclusive and normal mode for repository services?
Differences between connected and unconnected lookup?
Enterprise data warehouse your projects phase by phase explain?