Ab Initio Data Warehousing Question:

What are primary keys and foreign keys?

Ab Initio Interview Question
Ab Initio Interview Question

Answer:

In RDBMS the relationship between the two tables is represented as Primary key and foreign key relationship.Wheras the primary key table is the parent table and foreignkey table is the child table.The criteria for both the tables is there should be a matching column.


Previous QuestionNext Question
What is an outer join?Have you used rollup component? Describe how?