Interested to Buy Any Domain ? << Click Here >> for more details...
What is the purpose of joins in teradata and what are the available join types?
- 1 Answers
- 1175 Views
- I also Faced
- E-Mail Answers
Answer Posted / Nidhi Paswan
Joins in Teradata are used to combine rows from two or more tables based on a related column between them, known as the join key. The available join types include INNER JOIN (returns only matching rows), LEFT OUTER JOIN (returns all rows from the left table and matching rows from the right table), RIGHT OUTER JOIN (returns all rows from the right table and matching rows from the left table), FULL OUTER JOIN (returns all rows when there is a match in either the left or the right table), and SELF JOIN (joins a table to itself).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is node? How many nodes and amps used in your previous project?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
