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 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
How do you change a non-reusable transformation to reusable transformation?
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
What is mapping debugger?
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
Briefly define a session task?
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
Mention few power centre client applications with their basic purpose?
what is the difference between static and dynamic
Using Expression transformation how to remove duplicate records from a relational source?
what is shared Cache. when we will use shared Cache?
How to update or delete the rows in a target, which do not have key fields?