IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN
ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES
HOW?PLZ GIVE ME A EXAMPLE.
Answers were Sorted based on User's Feedback
Answer / oceanblue
Yes, you can have a column for Primary key and have another
column which will have no duplicates or null.
A Salary Table will have employee ID as primary key. The
table also contains TAX-ID which can not be null or duplicate.
|Is This Answer Correct ?||7 Yes||0 No|
Answer / rajiv senapati
|Is This Answer Correct ?||2 Yes||0 No|
how teradata fetches a row from primary index table?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Where we use PPI in real time??? What is the disadvantages of PPI?
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
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Aborted in Phase 1 data Acquistion Incomplete in fastload?
How to cast date "2015-03-03-012204-000000" to timestamp
Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....
Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE
How do you load Multiple files to a table by using fastload scripts?
can we join volatile table with general table an global temporary table with general table ?
Aborted in Phase 2 data acquistion completed in fastload?