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…
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…
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 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…
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,…
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…
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.…
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)
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…
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…
