Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / kishore


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

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  

How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  

How can you differentiate between powercenter and power map?

0 Answers  

how to insert header after each group.

1 Answers   IBM,

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

What is meant by target load plan?

0 Answers  

Under what condition selecting sorted input in aggregator may fail the session?

0 Answers  

What is dynamic cache?

0 Answers  

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,

For more Informatica Interview Questions Click Here
Categories