what is single value and Multivalue ?
Answer / srav
A single valued attribute is one that holds a single value for a single entity. Example: roll_number, name etc
Multivalued attribute is one that holds multiple values for a single entity.
Example: degree behold by a person (MS, PhD)
| Is This Answer Correct ? | 0 Yes | 0 No |
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?
Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M
What is the use of having index's on table?
Aborted in Phase 1 data Acquistion Incomplete in fastload?
Explain amp in teradata?
I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.
what is the default character set in teradata,,?
What do you mean by ttu in teradata?
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
in teradata level primary in table level allows duplicates why?
How can we load single row of data into teradata database. please give me the process.
What's the syntax of sub string?