Interested to Buy Any Domain ? << Click Here >> for more details...
How the informatica server increases the session performance
through partitioning the source?
- 1 Answers
- 8909 Views
- I also Faced
- E-Mail Answers
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 meant by active and passive transformation?
explain one complex mapping with logic? sales project?
How do you change a non-reusable transformation to reusable transformation?
Explain joiner transformation in informatica
How we can create indexes after completing the load process?
can we override a native sql query within informatica? How do we do it?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How many ways a relational source definition can be updated and what are they?
Tell me about MD5 functions in informatica
what are the Methods For Creating Reusable Transformations?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How to elaborate powercenter integration service?
Enterprise data warehouse your projects phase by phase explain?
How to create or import flat file definition in to the warehouse designer?
What is joiner change?
