what is the flat file partition and where have to specify it
Answer / 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 |
What is an unconnected transformation?
What is a test load?
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009
What is a candidate key?
How to eliminate duplicates from flat file..what is the procedure
When do you use sql override in a lookup transformation?
What is power center repository?
can you avoid static cache in the lookup transformation? I mean can you
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How are indexes created after completing the load process?
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,