Hi Raj, I assume your question is not an issue with how to trigger your recipe from new/updated data in one or more SQL tables, correct?
It appears your question is how to map data from multiple SQL Server tables to SF. More information on your requirements is needed to understand your questions, both on the SQL Server end and the SF API end.
Examples of additional information required: How many SQL tables and what entities are involved? Does data from each SQL table represent an individual (independent) transaction or do you need to gather data from multiple SQL tables to construct a parent-child (one to many) nested data structure that then needs to be mapped to SF? Does the data from the various SQL tables map to a single SF API or are there multiple SF APIs required?
