Is it possible to have more than one row on the same table
with the same foreign key?
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
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain what are the different types of join operations?
Can any one explain the hierarchies level data warehousing.
How can you communicate with web server (apache or iis) from coldfusion?
What are the different ways to represent the loading of dimension tables?
What are session timeout and application timeout? Where we have to do this process?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
Explain the definition of normalized and denormalized view and what are the differences between them?
What is the main difference between schema in rdbms and schemas in datawarehouse?
what is an use case?
Explain difference between snow flake and star schema.
Explain what is the difference between olap and datawarehosue?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
What is data cleaning? How can we do that?
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 ??????