In this tutorial, we will learn how to remove duplicate records from the file using Talend Open Studio Designer or how to store unique records from a file in Talend. Components Used : tFileOutputDelimited, tFileInputDelimited and tUniqRow The requirement is to read a source csv file having duplicate records. In this demo tutorial, we will read data from a file having duplicates and store unique records in a separate file and duplicate records in another file. ... https://www.youtube.com/watch?v=yIRgFT2dRTA

In this video of SSRS Tutorial, You will be learning How to add Dates parameters in SSRS Report to organise and visualise your data in a better manner. SSRS gives developers the ability to add custom code to their report layouts. Matrices provide functionality similar to cross-tabs and pivot tables. After our initial design, we can continue to develop a matrix to improve the viewing experience for the user. The Adjacent grouping functionality can be used to create separate groupings in the same table. These groups, while created in the same table, don't depend on each other. To learn more - please visit us as http://www.sql-datatools.com ... https://www.youtube.com/watch?v=3uB1FtMgJDg

In this tutorial, we will learn "How to calculate the Descriptive Statistics in the dataset by using Input tool and Field Summary tool" in Alteryx tool. The Field Summary tool analyzes data and creates a summary report containing descriptive statistics of data in selected columns. Use the Field Summary Tool to gain insight into data and receive recommendations for managing data. Numeric, string, spatial, and date/time are supported in this tool. A unique set of descriptive statistics are provided for each data type. See Data Types for more on types of data. Descriptive Summary - It is used to show descriptive statistics like mean, median, mode, max, min, etc. It is generally used to understand the distribution of the variables present in the data. In Alteryx, choose the Field summary tool from the Data investigation tab in order to calculate the descriptive statistics of all the variables present in the data set. To learn more, please follow us - http://www.sql-datatools.com To Learn more, please visit our YouTube channel at - http://www.youtube.com/c/Sql-datatools To Learn more, please visit our Instagram account at - https://www.instagram.com/asp.mukesh/ To Learn more, please visit our twitter account at - https://twitter.com/macxima To Learn more, please visit our Medium account at - https://medium.com/@macxima ... https://www.youtube.com/watch?v=301E3tbEBno

In this tutorial, we are going to explain the functionalities of Execute Package Task to call multiple child packages in SQL Server Integration Services. The Execute Package task extends the enterprise capabilities of Integration Services by letting packages run other packages as part of a workflow. For more information, please visit us at http://www.sql-datatools.com/2016/04/ssis-object-types-variable-in-execute.html ... https://www.youtube.com/watch?v=RP-Fy09k_Cc