Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

alvinford
New Contributor III

What is the Answer ?

Following is the interview question, which is posed by the interviewer in the recent interview.Would like to know the answer for this.

And also come content on these kind of questions.

  1. There is a schema given, table A to C is one to many and B to C is one to many. What is the relation between A and B
    1. a. One to many
    2. b. Many to many
    3. c. Many to one

Regards,

Alvin.

Tags (1)
13 Replies

Re: What is the Answer ?

many to many

bestofwest
Contributor II

Re: What is the Answer ?

many to many.

cartesian....

michael_gardner
Contributor III

Re: What is the Answer ?

Personally think it's a bad question for a QV Developer but this image illustrates the answer.

Orders can have many Products and Products can have many orders.  So this is a many to many relationship.

manymany-links-lg.gif

Not applicable

Re: What is the Answer ?

Hi,

I think , answer is many to many .

mukesh24
Contributor III

Re: What is the Answer ?

Hi,

Many to many

Not applicable

Re: What is the Answer ?

many to many

Re: What is the Answer ?

... unless it is being posed a trick question, as depending on the data and whether the key fields are unique or not it could be any of the three answers.

michael_gardner
Contributor III

Re: What is the Answer ?

That was what I initially thought as well.  Unless Table C is defined as a Junction Table it does seem it could be any of the answers.

Re: What is the Answer ?

Depends on how Table C is joining table between A an B... General Scenario it is Many to Many but as Bill said, it could be any answer...

Community Browser