which join mostly use in realtime?

Answers were Sorted based on User's Feedback

which join mostly use in realtime?..

Answer / tdguy

Depends on business requirement.

Is This Answer Correct ?    1 Yes 0 No

which join mostly use in realtime?..

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

Post New Answer

More Teradata Interview Questions

Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  

plz explain parlla distribution and subtable concept in teradata

3 Answers   TCS,

Highlight the limitations of TPUMP Utility.

0 Answers  

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

2 Answers  

write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?

3 Answers   IBM,

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

0 Answers  

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

6 Answers   IBM,

What is a dimension table?

0 Answers  

What is meant by Teradata Gateway?

0 Answers  

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.

4 Answers  

What are the various reporting tools in the market?

0 Answers  

How do you load Multiple files to a table by using fastload scripts?

1 Answers   Satyam,