Informatica - Hi,1.Can anyone explain all the 4 partitions in Informatica and on which table what partition is use

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 7 of 300

Hi,
1.Can anyone explain all the 4 partitions in Informatica and on which table what partition is used?
2.Suppose we have 4 columns in a table primary key, 2 string columns and a numeric column? While doing a group by aggregator what is the order that we have to group by?

Thanks,
Arpita.

Total Answers and Comments: 3

Last Update: April 15, 2007 Asked by: Arpita

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 31, 2006 05:42:42

Jagadeesh

RE: Hi,1.Can anyone explain all the 4 partitions...

This Tuning is some what typical based on your requirement.

Partitioning the data is not first level.. Inorder to improve performance partioning is not only the soln... In your scenario... First upall usage of Sorted out put is important and then setting the cache is next nest.. then whether to use incremental aggragation is necessary or not u need to check...

for this aggregation it self we can have some nealry 10 check points to do tuining.

Partion is only one among them...

U can chek Informatica pdf for partiioning methods..

Other wise write a mail to me specifying ur problem or scenario....

From

Jagadeesh

Is this answer useful? Yes | No

May 29, 2006 03:30:14

VS HARI

RE: Hi,1.Can anyone explain all the 4 partitions...

Hi,

Can you please mail me the Powercenter 6 pdf. The doc which contains the information regarding various transformation.

Thanks

V. Hari

Is this answer useful? Yes | No

April 15, 2007 04:05:11

raju

RE: Hi,1.Can anyone explain all the 4 partitions...

Hi Hari,,

As per my knowledge data partition are like as

1. Round Robin
2. Pass-through
3. Hash key
4. Key range

Is this answer useful? Yes | No

Go To Top