Teradata Studio: How to change query font size in SQL Editor?
If you need, you can easily change font size in Teradata Studio for Query, Answerset or History window. Increasing or decreasing font size in Teradata Studio can quickly improve your…
MS Excel VBA: How to add Developer tab in Microsoft Excel?
Programming in VBA can significantly speed up and facilitate your work. Visual Basic for Applications is a programming language implemented in Microsoft Office programs that you can use to write…
MS Excel – How to create drop-down list in Excel?
Manual input of data in MS Excel forms and text cells can lead to many errors and occurrence of dirty records in your data. If the user makes e.g. 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…
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…
Data migration – conversion of data types from MS SQL Server to Teradata
Data migration between two different database systems always involves the conversion of data types. In this post, I will introduce the concept of data migration and show how to convert…
Photo by Kaitlyn Baker on Unsplash
How to put new line at the same cell in Microsoft Excel file
When you press the Enter button in Microsoft Excel file, cursor move you to the next cell. If you want add break line between lines or paragraphs of your text,…
How to connect to server with private key using PuTTY
Often, instead of the standard username and password, you would like to use a private SSH key to connect to remote host via SSH. In this short post, I will…
Teradata: Failure 7547 Target row updated by multiple source rows
You will get this error code when try update the target table using multiple records from source. It completely does not matter if you use MERGE or direct UPDATE statement.…