What are the joins in teradata?
No Answer is Posted For this Question
Be the First to Post Answer
1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?
6 Answers Bank Of America, Wipro,
Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance
How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
How would you load a very large file in teradata in general?
What are the joins in teradata and how many types of joins are there in teradata?
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?
What is the difference between fastload and multiload? Which one is faster?
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
how can we analyze the locks ?
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
While creating table my dba has fallback or no fallback in his ddl. What is that?