Search This Blog

Welcome To Datawarehouse World

Left Outer Join in teradata?...

Get link
Facebook
X
Pinterest
Email
Other Apps

January 15, 2023

Select A.MovieName, B.ActorName

From Movie_List A

Left Outer Join Actor_List B

On (A.Movie_No = B. Movie_No);

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Temp Space in Teradata?...

January 15, 2023

Temp Space : It's a unused space in Permanent Space and the Global Temp Table is used the Temp space.

General information about Netezza : Default Error details

July 26, 2017

General information about Netezza : Default Error details There are around 140 default error details available in Netezza. For your reference please find below details. ERRORCODE ERRORTEXT 1 Operation failed 2 Interaction aborted 3 Statement aborted 4 Could not serialize - transaction aborted 5 Transaction no longer active 6 Out of memory 7 Incorrect data type 8 Illegal value 9 Internal: SPUs crosstalking 10 Internal pipe I/O failed 11 Cannot determine hostname 12 Rogue SPU trying to register 13 No such table exists 14 No such field exists in table 15 Table already exists 16 Plan already exists in plan dictionary 17 F...

Minus in Teradata?...

January 14, 2023

Minus : It will provide the result which one is not matching from both tables... Note: It will provide the not matching result from first select table only. Select Emp_No from Emp Minus Select Emp_no from Emp_Dep;