What are different types of partitioning in Informatica

[@sakshipardeshi2007]

Say I have 10 partitions does each partition launches one session while execution. Session as in database session?

[@electricalproject1920]

Very helpful thank you sir

[@sureshetltrainer]

Thank you Keep watching

[@sakshipardeshi2007]

What is exactly database partitioning...how do we configure it..

[@youtubetrolls1239]

how many ranges we can define for key range?

[@sureshetltrainer]

No limit

[@SB-ln3ln]

@sureshetltrainer could you please clear my doubt, Your input will be appreciated. Thanks In Advance. As a Informatica developer do we have any involvement or any work part we do in partitioning, Do i get question in interview on partitioning. or partitioning is admin or support team work.?

[@sureshetltrainer]

It is not admin work..To improve performance one of methods partitioning

[@SB-ln3ln]

​@@sureshetltrainer Tq for Quick Response. Once after completing Task or Story will perform partition regularly or in which case will perform partitioning could you please give example.Tq In Advance

[@bhanuroyal__1]

Can you upload video for stored procedures sir? Better you can show us practically in informatica tool sir so that it should be more clear for everyone.

[@sureshetltrainer]

Sure let me upload

[@bhanuroyal__1]

@@sureshetltrainer thank you sir

[@bhavyalekha9580]

Is there openings for informatica powercenter for 2.8years experience candidates? If yes please provide details.

[@sureshetltrainer]

4 to 8 years experience will usually have calls..but not less than that..

[@bhavyalekha9580]

@@sureshetltrainer if we have experience in powercenter and iics then?

[@sureshetltrainer]

@@bhavyalekha9580 you may have but less only

[@bhavyalekha9580]

@@sureshetltrainer thank you for the response please post the details if you have any openings

[@sureshetltrainer]

@@bhavyalekha9580 sure will do

[@KrishnaveniBattina-w2d]

Can you please give us an example with date for the Key portioning.Thanks

[@sureshetltrainer]

Sure will try

[@user-dz6it8wr6e]

Sir I have one scenario can you pls help me on this I have a parameter file: $$filename : abc.05/04 After 10 days one file added $$filename : abc.10/04 How to load this file dynamically can you explain.