Interested to Buy Any Domain ? << Click Here >> for more details...
How the informatica server increases the session performance
through partitioning the source?
- 1 Answers
- 8995 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 the difference between writing a joiner query in ANSI style and THETA style?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What if the source is a flat-file?
How to elaborate tracing level?
How do you load first and last records into target table?
Tell me about MD5 functions in informatica
What is the fact table?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
design of staging area?
What is a repository manager?
What are the main issues while working with flat files as source and as targets ?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How can repository reports be accessed without sql or other transformations?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
