Is it possible to have more than one row on the same table
with the same foreign key?
- 2 Answers
- 6658 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Explain how to generate iqd file from framework manager?
What is the purpose of Dataware Control?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
