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 joiner transformation in informatica?
What do you understand by a term domain?
Suppose we do not group by on any ports of the aggregator what will be the output?
Which are the different editions of informatica powercenter that are available?
How to extract the informatica rejected data?
What are different types of transformations available in informatica?
What is the use of an aggregator cache file?
According to his methodology what all you need before you build a datawarehouse
What is the use of target designer?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are the different types of olap? Give an example?
How do you convert single row from source into three rows into target?
What do think which one is the better joiner or look up?
Differentiate between a database and data warehouse?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me