Ab Initio Data Warehousing Question:

Download Job Interview Questions and Answers PDF

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.

Download Ab Initio Interview Questions And Answers PDF

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