what is the flat file partition and where have to specify it



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

Post New Answer

More Informatica Interview Questions

What is the need of building a data warehouse?

2 Answers  


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

2 Answers   IBM,


What are events in workflow manager?

1 Answers   Accenture, IBM,


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. ?

0 Answers   CTS,


Describe two levels in which update strategy transformation sets?

1 Answers  






list out all the transformations which use cache?

0 Answers   Informatica,


Which are the different editions of informatica powercenter that are available?

0 Answers  


version controlling in informatica?

3 Answers  


explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,


how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,


What is galaxy shema

2 Answers   CGI,


What aer the out put files that the informatica server creates during the session running?

4 Answers  


Categories