Problem Statement Given a 32-bit signed integer, determine its reverse. Since we can have signed integer we can have negative values, so for Input => -123 Output => -321, also need to take care of Overflow cases which should results…

Skip to content
Skip to main menu
# Scala Interview Question – Reverse Integer

Problem Statement Given a 32-bit signed integer, determine its reverse. Since we can have signed integer we can have negative values, so for Input => -123 Output => -321, also need to take care of Overflow cases which should results…

# SSIS Interview Questions (Data Flow Transformations)

# MDX Calculations Part 4 – COUNT Aggregation Function

# SSIS Interview Questions (Basics for Beginners and Experienced)

# MDX Calculations Part 3 – Subcube Vectors, Solve Order, Block vs Cell By Cell Computation

# Optimizing Bitmap Indexes during Partition Processing in SSAS Multidimensional

# Bulk Loading data into COLUMNSTORE table

# Bulk Loading data into HEAP versus CLUSTERED Table

# Optimizing (Fact) Partition Processing in SSAS Multidimensional

# Understanding Partition(Fact) Processing in SSAS Multidimensional

Learn sql, mdx and big data here !!

Questions for Lookup transformation Q1) How matching happens inside the lookup transformation? Lookup transformation performs an equi-join between input data and lookup dataset. By default unmatched row is considered as an error however we can configure lookup to redirect such…

MDX Numeric Aggregation Function COUNT() There are a number of important functions in MDX that return numeric values. Lets start with the Count() function, which takes a set and returns the number of items in the set. Even if this function…

In these set of Interview Question we will learn about basics of SSIS such as Data flow, Control flow, Various different type of data flow transformations, Execution Trees and Buffers

Understanding Block vs Cell By Cell Computation The key idea behind subspace computation is best introduced by contrasting it with a cell-by-cell evaluation of a calculation. (This is also known as a naïve calculation.) Consider a trivial calculation RollingSum that sums…

When MDX query is issued on SSAS Server it goes through Formula Engine which request data from Storage Engine, and it either retrieves data either from cache or aggregations or from partition/fact data files (see this article for Understanding MDX…

Bulk loading is the most performant way to move data into a columnstore index because it operates on batches of rows. Bulk loading fills rowgroups to maximum capacity and compresses them directly into the columnstore. Only rows at the end of…

Bulk Loading into HEAP Generally, the fastest way to load data into SQL Server table is by Bulk Loading data into HEAP using TABLOCK hint on destination table which facilitates minimally logging. For more details see Fastest Data Loading using Bulk Load and Minimal…

The performance goal of partition processing is to refresh Cube/OLAP data in an efficient manner that does not negatively impact the query performance of dependent partitions. The following techniques for accomplishing this goal are discussed in this section:

In Analysis Services, when we first DEPLOY a database it contains only objects but not data. When we PROCESS a database, it directs the server to recursively process those objects that store data in the model, such as dimensions(see Understanding Dimension Processing in SSAS…