Is it possible to have more than one row on the same table
with the same foreign key?
- 2 Answers
- 5584 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can you pass sql queries in filter transformation?
What are the stages of datawarehousing?
What are modeling tools available in the market?
How to handle multi value dimensions?
Explain the versions of reportnet?
What is the difference between drill through and masterdetail reports?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
How can we do data cleaning?
Can we start and stop single session in concurent bstch?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
Why null values are mapped as 0 in fact tables?
What are data modeling and data mining?
Explain what is data validation strategies for data mart validation after loading process?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
