How to install Microsoft Teams on Windows 7 or Windows 10?
Recently, Microsoft Teams has been gaining more and more popularity among users. All in all, it is not surprising, because currently on the market it is difficult to find a…
Talend Data Integration – Free online course
Are you wondering how to start your adventure in the IT? Are you interested in data warehouses and data integration, but you do not know where to start? Talend Data…
How to install Microsoft Teams on Ubuntu 18.04 (Linux)?
Recently, Microsoft Teams has been gaining more and more popularity among users. All in all, it is not surprising, because currently on the market it is difficult to find a…
How to use Lombok @Builder in abstract java class?
The answer is - you cannot, but you can use @SuperBuilder annotation instead of @Builder. @SuperBuilder was introduced as experimental feature in lombok v1.18.2.@SuperBuilder's toBuilder feature and limited support for…
How to use Pivot SQL function in Microsoft SQL Server
Sometimes you got business requirements to create new view or dashboard and to do this you need to convert rows to columns. You can transpose them on two ways: using…
Apache Spark: Convert DataFrame to DataSet – Scala
Many times you might want to have strong typing on your data in Spark. The best to get it is to DataSet insted of DataFrame. In this post I give…
Apache Spark: ReduceByKey vs GroupByKey – differences and comparison
In this post I will try to introduce you to the main differences between ReduceByKey and GroupByKey methods and why you should avoid the latter. But why? The answer is…
Teradata: How to convert rows to columns? Pivot function at Teradata.
Sometimes you got business requirments to create new view or dashboard and to do this you need to convert rows to columns. You can transpose them on two ways: using…
Teradata: What is the difference between CASESPECIFIC and NOT CASESPECIFIC data type attributes?
When you create tables, you can set a lot of data type attribues like CHARACTER SET, FORMAT, UPPERCASE or (NOT) CASESPECIFIC. CASESPECIFIC attribute specifies case for character data comparisons and…
Oracle Database: How to check if the table has a primary key. Types of constraints
A constraint is a rule that you define and its task is to protect the table from clutter that may arise as a result of adding incorrect or incomplete data.…