QlikView – Synthetic Key
A Synthetic Key is QlikView's solution to create an artificial key when there is ambiguity about which key to use between two tables. This situation arises when two tables have two or…
A Synthetic Key is QlikView's solution to create an artificial key when there is ambiguity about which key to use between two tables. This situation arises when two tables have two or…
Redis HEXISTS command is used to check whether a hash field exists or not. Return Value Integer reply, 1 or 0. 1, if the hash contains a field.0 if the hash does…
Redis HDEL command is used to remove specified fields from the hash stored at the key. Specified fields that do not exist within this hash are ignored. If the key does not…
A start schema model is a type of data model in which multiple dimensions are linked to a single fact table. Of course, in bigger models, there can be multiple…
Redis Hashes are maps between the string fields and the string values. Hence, they are the perfect data type to represent objects. In Redis, every hash can store up to…
Dimensions and Measures are fundamental entities, which are always used in data analysis. For example, consider the result of the analysis, “what is the percentage change in volume of sales for…
The Rotating table in QlikView is similar to the column and row transpose feature in Microsoft Excel but with some additional options. We can transpose columns in multiple directions and…
Redis APPEND command is used to add some value in a key. Return Value Integer reply, the length of the string after the append operation. Syntax Following is the basic syntax of…
Column Manipulation is a type of Data Transformation in which a new column is populated with values from an existing column, which meets certain criteria. The criteria can be an…
Redis DECRBY command is used to decrement the number stored at the key by the specified value. If the key does not exist, it is set to 0 before performing the operation.…