Is PK concept available in Teradata. If it is how can we
create Primary Key for a table in TD
- 6 Answers
- 10840 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / santhosh
In teradata for storing and retrieving purpose, PE will use
primary index only.. but we are using PK in teradata for creating joins.. soo in Teradata we are using PK and FK..
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What does sleep function does in fast load?
What is the difference between fastload and multiload? Which one is faster?
Why do you get spool space errors? How do trouble-shoot them?
Explain vproc in teradata?
If a Node is busy what are the steps you can take to avoid ?
How to run a query in teradata?
In general, how do you optimze any sql in teradata?
What is meant by a Highest Cost Plan?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What are differences between teradata and ansi session modes in teradata?
Explain teradata utilities?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Describe the set operators in teradata.
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What are the advantages of teradata?
