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


Please Help Members By Posting Answers For Below Questions

Briefly define reusable transformation?

624


What is the difference between informatics 7x and 8x and what is latest version?

547


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

557


Mention some types of transformation?

607


What is repository manager?

536






What is main use of mapplet?

658


How does a rank transform differ from aggregator transform functions max and min?

671


explain one complex mapping with logic? sales project?

6150


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1011


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1469


What is rank transformation in informatica

691


What is the Process to creating lookup transformation in informatica

585


What is Index Caches size?

620


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1627


Enlist the differences between database and data warehouse.

550