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.…
Ubuntu Linux: How to create, copy, move or delete files and directories?
In this post I will show you how to create, copy, move and remove files and folders at Ubuntu Linux operating system. Creating files and directories Usually files are created…
![[SOLVED] Teradata: [Error 3854] [SQLState HY000] <your object name> is not a view.](https://bigdata-etl.com/wp-content/uploads/2019/12/Untitled-1-300x180.png)
[SOLVED] Teradata: [Error 3854] [SQLState HY000] <your object name> is not a view.
In this post I will explain why you encountered an error [Error 3854] [SQLState HY000] <your object name> is not a view while executing the DDL query at Teradata, what…
Repository Navigator disappeared completely after undocking in Informatica Powercenter 10.1.1 – how to reset it?
Sometime if you undocking your Repository Navigator from one of the Informatica tools (e.g. Designer, Workflow Manager) and close it, your Repository Navigator can completely disappreared. So you cannot dock…
SQL Server: How to check column data types in SQL Server database?
There are at least a few ways to get column data types in Microsoft SQL Server database. In this short post, I will show you two the most popular ways…
SQL Server: How to extract only year, month or day from date data type?
If you used databases like Oracle or Teradata, you can be suprised that very popular function like extract(year from date) not work for Microsoft's databases. In this post I show…
Photo by Hannah Joshua on Unsplash
SVN: Command Line Interface (CLI) for TortoiseSVN
In this post, I will show you how to enable running commands on the Windows operating system for TortoiseSVN. At TortoiseSVN default settings, you can only use the Graphical User…
SVN: How to create a new branch and clone the repository?
In this short post I will show you how to create a new branch in the SVN repository and how to make a copy of the main repository in your…
Photo by Jeroen den Otter on Unsplash
How to compare two files in Notepad++ v7.8.1
In this post I will show you how to compare two files in Notepad ++. In the latest versions of the tool (such as v7.8.1), installing the Compare plugin is…
![[SOLVED] Teradata: [Error 3504] [SQLState HY000] Selected non-aggregate values must be part of the associated group.](https://bigdata-etl.com/wp-content/uploads/2019/12/john-schnobrich-FlPc9_VocJ4-unsplash_ENG-2-300x200.jpg)
Photo by John Schnobrich on Unsplash
[SOLVED] Teradata: [Error 3504] [SQLState HY000] Selected non-aggregate values must be part of the associated group.
In this post, I will explain why you encountered an error [Error 3504] [SQLState HY000] Selected non-aggregate values must be part of the associated group while executing the SQL query…
- 1
- 2
