When you need to retrieve all content of a specific property from a Page/Block type, normally you will use the IContentLoader or IContentRepository, or even IContentModelUsage to get all instances of a content type then select them by property. This is the correct implementation by code. But what if you only need to check the […]
Posts Tagged ‘MS SQL Server’
Slowly Changing Dimension(SCD) TYPE 3 in Informatica PowerCenter
What is a Slowly Changing Dimension? Slowly Changing Dimension (SCD) is a dimension that allows us to store and manage both current and previous data over time in a data warehouse. It is considered and implemented as one of the most critical ETL tasks in tracking the history of dimension records. There are three types […]
Implementation of SCD type 1 in Informatica PowerCenter
What is a Slowly Changing Dimension? A Slowly Changing Dimension (SCD) is a dimension that stores and manages both current and historical data over time in a data warehouse. It is considered and implemented as one of the most critical ETL tasks in tracking the history of dimension records. Type 1 SCDs – Overwriting In […]
SQL Best Practices and Performance Tuning
The goal of performance tuning in SQL is to minimize the execution time of the query and reduce the number of resources while processing the query. Whenever we run the query, performance depends on the amount of data and the complexity of the calculations we are working on. So, by reducing the no of calculations […]
ETL & SQL : The Dynamic Data Duo
Data is the lifeline of any modern organization. At any point, every day, you work on molding data points into information to derive profits. Therefore, having the right building blocks is a crucial part of running a good business. This is where the dynamic duo of ETL and SQL comes into play. While you may […]
Basic Understanding of Full Load And Incremental Load In ETL (PART 1)
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 […]
How to create cascading parameters in Reporting services (SSRS)
What is SSRS? SSRS stands for SQL Server Reporting Services. It is a reporting tool developed by Microsoft that comes free with the SQL Server. It produces formatted reports with the tables of data, graph, and reports. Reports are hosted on a server and configured to run using parameters supplied by users. When we run the […]
How to create zip file which contains single text file with a fixed threshold in SSIS.
What is SSIS? SQL Server Integration Service (SSIS) is a component of the Microsoft SQL Server database software that can be used to execute a wide range of data migration tasks. The SSIS ETL tool Extracts data from different sources and transforms that data according to user requirements. And then loads data into various destinations. […]
Type tree creation using ITX Database Interface Designer
IBM Transformation Extender (ITX) is one of the most powerful data transformation product and its supportability of multiple protocols and routing capabilities has made it a unique product delivering flexibility in IT systems, resulting in business agility.It has the ability to transform any type of data to any specific format with formats including XML,Non XML, Cobol Copybook,EDI […]