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 Partitioning ? where we can use Partition?

Question Posted / guest

Answers were Sorted based on User's Feedback



what is Partitioning ? where we can use Partition?..

Answer / mahesh

The Partitioning Option increases Power Center?s
performance through parallel data processing, and this
option provides a thread-based architecture and automatic
data partitioning that optimizes parallel processing on
multiprocessor and grid-based hardware environments.
Partitions are used to optimize the session performance. We
can select in session properties for partitions
Types- Default----pass through partition, key range
partition, round robin partition, hash partition.

Is This Answer Correct ?    28 Yes 5 No

what is Partitioning ? where we can use Partition?..

Answer / annu

Partitioning is a utility provided by informatica which
evolves nature of parallel processing on a grid or
multiprocessor database architecture. Partition means
a "thread of ETL data load in chunks". Like Unix, Multiple
data load thead will be executed parallely and sync up the
result set to one instance of Target.

For more detail of using Informatica Partitioning with
visual graphs
visit : http://informatica-tech-talk.blogspot.com/

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is song in infrmatica...?

0 Answers   CTS,

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

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

2 Answers   Polaris,

Why sorter is an active transformation?

0 Answers   Informatica,

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

What is source qualifier?

6 Answers   SDS,

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,

what is unique constraint error ?

2 Answers   TCS,

What are the issues you have faced in your project? How did you overcome those issues?

0 Answers   CTS, FEEE, TCS,

What is the difference between a router and a filter transformation?

1 Answers   TCS,

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

0 Answers  

For more Informatica Interview Questions Click Here
Categories