Answers were Sorted based on User's Feedback
Answer / tdguy
Depends on business requirement.
|Is This Answer Correct ?||1 Yes||0 No|
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
|Is This Answer Correct ?||3 Yes||4 No|
Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?
plz explain parlla distribution and subtable concept in teradata
Highlight the limitations of TPUMP Utility.
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
write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table
What is a dimension table?
What is meant by Teradata Gateway?
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.
What are the various reporting tools in the market?
How do you load Multiple files to a table by using fastload scripts?