//Info: JOIN-185 Requirement: Create a MapReduce script to delete the Sales order Records.In these cases, Normally we set a saved search criteria to met the requirement & retrieve the data’s from the search script and then proceed with the Deletion mapping. In case of sales order, we have multiple set of records linked to a… Continue reading Delete Multiple Records By Calling Array Elements
Author: Bibin Thomas
SQl Server Integration Services (SSIS)
SSIS simply helps to Migrate data’s from Netsuite to outside Databases which are mainly loaded in SQL server.Mostly Export is done through Visual studio Community towards SQL Server which is located in Microsoft Azure platform. Part_1: Netsuite Connection Setup through SuiteAnalytics Connect(ODBC Driver) Part_2: Creating a project in Integration Services Project Template(Visual Studio community) Part_3:… Continue reading SQl Server Integration Services (SSIS)
To Change default Start Index Of line Number
Info: SCT-30 The Default starting Index of Line item counts with Zero initially. This is unpracticable in cases where we have to know the Total Line or Item length correspondingly. Can be easily done through a single Index/ Count Field id according to the requirement. //Starts with Line number 0 //Starts with line number 1