Full Load: Full Load in ETL is loading ALL the data from the source to the destination. A target table is truncated before loading everything from the source. That’s why this technique is also known as Destructive Load. In full load first we truncate the destination table and then we load all the data from source […]
Feature of Snowflake: Zero Copy Cloning
Feature of Snowflake: Zero-Copy Cloning Zero Copy Cloning in Snowflake: Snowflakes have some advanced feature like Time Travel, zero-copy cloning […]
Feature of Snowflake: Time Travel
Snowflake: Snowflake’s data cloud is powered by advanced data platform provided as software as a service. Snowflake enables data storage, processing, […]
How to Convert Blank Values to Null in Flat File Source in SSIS Package
SQL Server Integration Services(SSIS): SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading. In […]
How To Create Reports Using SQL Server Reporting Service(SSRS)
SQL Server Reporting Services (SSRS) is a SQL Server subsystem that enables the creation of graphical, Mobile and printed reports using SQL Server and other data sources. It is part of Microsoft SQL Server Services suite. SQL Server is a relational database management system (RDBMS) that supports transaction processing, business intelligence and analytics applications. […]