Is it possible to have more than one row on the same table
with the same foreign key?
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 |
What is query panel?
Explain about Control M JObs detaily?How to execute this.
2 Answers Scope International,
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
What is difference between Business Objects and Hyperion Essbase? Please help me
How to improve session performance in aggregator transformation?
Explain Process flow in data warehouse??
How to know the time taken for particular report execution?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
How can Oracle Materialized Views be used to speed up data warehouse queries?
What is BCP?
What is the difference between star and snowflake schemas?
What is ETL process in Data warehousing?