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
what is the size of your data warehousing?
What is DR strategy for Informatica project?
Write the unconnected lookup syntax?
Plz can any one say me how to get the informatica certification materials and dumps
What is the need of an ETL tool?
What is domain and gateway node?
What is the difference between a repository server and a powerhouse?
pmscmd startworkflow -sv
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
As union transformation gives UNION ALL output, how you will get the UNION output?
What is a connected transformation?
How does a sorter cache works?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Informatica settings are available in which file?
Explain target update override in informatica