what is the flat file partition and where have to specify it
Answer Posted / prabhu
After you tune the application, databases, and system for
maximum single-partition performance, you may find that the
system is under-utilized. At this point, you can configure
the session to have two or more partitions.
You can use pipeline partitioning to improve session
performance. Increasing the number of partitions or
partition points increases the number of threads.
Therefore, increasing the number of partitions or partition
points also increases the load on the nodes in the
Integration Service. If the Integration Service node or
nodes contain ample CPU bandwidth, processing rows of data
in a session concurrently can increase session performance.
Prabhu
www.iskilltech.com
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the etl program with few examples.
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are the different clients of powercenter?
What are batches?
Parameter and variable differences
Have you worked with/created Parameter file
Enlist few areas or real-time situations where informatica is required.
What is the difference between informatica 7.0 and 8.0?
What do you mean by filter transformation?
What are the issues you have faced in your project? How did you overcome those issues?
Could you explain what is enterprise data warehouse?
How to do unit testing in informatica?
Explain the aggregator transformation?
Why union transformation is an active transformation?