I need to know Limitations of implementing InfoPath forms in SharePoint before I deploy it. Can someone please help me out?
All Infopath disadvantages are counterparts or well-thought intentional Microsoft's architectural genial decisions.
For example, unavailability of Infopath template projects in Visual Studio 2010 is for common's good to leverage common platform and independence on versions of tools founded (or continued) by Infopath Designer 2010's VSTA restricted back to .NET 2.0 and Visual Studio 2005 Tools for Application
So, any disadvantage of Microsoft technology is just misunderstood or unappreciated genial and innovative advantage
Infopath Designer is the tool for creating XML-based forms, i.e. XML data for forms and their content, which can be used by Sharepoint server as mostly uncontollable by developers add-ins for generating web parts and New/Create/Insert-Edit/Update/Modify-Display/View pop-ups/modes to web pages as very limited and mostly uncontrollable for development components while their most power and flexibility lie in client (non-browser-based) forms.
Like any tool, the solution should depend on the problem you are trying to solve.
I believe its root intention was for an electronic forms tool with templates that could be easily created by regular information workers, and not required to be developed by "programmers" who would do regular web forms in ASP.NET. I think its a great tool that definitely has some great uses.
Where it has perhaps come up short is end users hardly ever build forms. Instead they are built by either developers or developer-like people. The developers tend to come up with sophisticated solutions that may or may not be best suited for the technology. As an example, I have a pretty strict edict that says "never add managed code (.net) to an InfoPath form" since it complicates the deployment and management of that form with SharePoint. At the same time, many aren't so strict and do that.
Given a given problem, I work with my clients to find the right solution. Sometimes it is InfoPath, sometimes it is not. Within a given organization, there are likely reasons to use both approaches depending on the specific problem.
But, taking into account all the IP limitations, there are many situations were IP forms is the wise decision.