which join mostly use in realtime?
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
I am not sure whether a specific join would be used in
common. But if delta logic is used, outer joins would be
used.
| Is This Answer Correct ? | 3 Yes | 4 No |
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
what are the default access rights in the teradata?
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,
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.
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
How you will check the version of teradata?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Can you fastexport a field, which is primary key by putting equality on that key?
which utitility can use for loading the data from non-teradata to teradata ?
what do you mean by INMOD Routines and OUTMODE Routines ?
How do you see a ddl for an existing table?
How would you load a very large file in teradata in general?