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 |
How many ways you create ports?
Define Update Override?
Types of error logs in Informatica?
how to sort date field in infomatica?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
How we can create indexes after completing the loan process?
How does the aggregator transformation handle null values?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
Explain sessions and how many types of sessions are there?
How to do the error handling of if ur source is flatfiles?
source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?
how to load only the first and last record of a flat file into the target?