Is it possible to have more than one row on the same table
with the same foreign key?
- 2 Answers
- 5355 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naveen
Yes, it is possible.
Eg., EMP table consists of many employee records where each
employee is designated to one department#.Here the
department# is the foreign key in the emp table.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / pradeeshkumar
Yes, it's possible.
A foreign key in a table can have duplicate values.
For example, One or more employees can belong to same
project.EMPLOYEE_ID is the ptimary key of the Employee
table and PROJECT_ID is a foreign key that references
another table(Project).
EMPLOYEE_ID EMPLOYEE_NAME PROJECT_ID
----------------------------------------
0001 SAM DEX01
0002 MARK DEX01
0003 JUKE MKX02
| Is This Answer Correct ? | 6 Yes | 0 No |
Explain the difference between data ware house & data mart?
Describe a data warehouse.
What is the limit to the number of sources and targets you can have in a mapping?
What are the different ways to represent the loading of dimension tables?
How can we run the graph? How can we schedule the graph in unix?
How Materialized Views are linked with Oracle DataWare house?
what are the all possible features supported modify stage?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Can a dimension table contain numeric values?
What is the function of etl when used in data warehousing?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
Can you explain how analysis service works?
Teradata 
