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 the need of building a data warehouse?
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
What are events in workflow manager?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Describe two levels in which update strategy transformation sets?
list out all the transformations which use cache?
Which are the different editions of informatica powercenter that are available?
version controlling in informatica?
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
What is galaxy shema
What aer the out put files that the informatica server creates during the session running?