Problem Statement Given a 32-bit signed integer, determine whether that integer is a palindrome. Do this without converting it to string.

Skip to content
Skip to main menu
# Scala Interview Question – Palindrome Number

Problem Statement Given a 32-bit signed integer, determine whether that integer is a palindrome. Do this without converting it to string.

# Scala Interview Question – Reverse Integer

# 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

Learn sql, mdx and big data here !!

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

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: