Answer Posted / naresh
Cardinality is a property of a join that describes how many
rows in one table match rows in another table. Cardinality
is expressed as the minimum and maximum number of rows in a
column at one end of a join, that have matching rows in the
column at the other end of the join. The minimum and the
maximum number of row matches can be equal to 0, 1, or N.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
8. How much supervision have you typically received in your previous job?
What is the profile and package?
In banking domain how many Fact tables,Dimension table are present?
What is the functional & architectural differences between business objects and web intelligence reports?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What is the difference in creating filters in designer and business objects?
What would you consider as your biggest achievement and why?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain is there any other repository domains rather than universe, security, document?
What are the join problems comes appart from loop,chasm & fan Traps
What is the difference between condition & filter?
U r project in which stage in implementation?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?