Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
Name the foreign key columns in dimension and fact table?
Home
Informatica
Name the foreign key columns in dimension and fact table?
asked
Jun 6, 2021
in
Informatica
by
rajeshsharma
(
23.9k
points)
Name the foreign key columns in dimension and fact table?
informatica-fact-table
fact-table-dimension
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Jun 6, 2021
by
rajeshsharma
(
23.9k
points)
Dimension Table’s foreign keys are primary keys of entity tables
Fact Table’s foreign keys are primary keys of dimension tables
Related questions
0
votes
Q: Define Fact Table in informatica
asked
Jun 6, 2021
in
Informatica
by
rajeshsharma
(
23.9k
points)
informatica-fact-table
fact-table
0
votes
Q: What are the key columns in Fact and dimension tables?
asked
Oct 20, 2019
in
Dataware house
by
rajeshsharma
(
23.9k
points)
fact-table
dimension-table
0
votes
Q: What should be considered when you are asked to select the distribution key columns for a very large fact table?
asked
Feb 19
in
Netezza
by
rajeshsharma
(
23.9k
points)
netezza-coloumn
0
votes
Q: Define Dimension Table in informatica
asked
Jun 6, 2021
in
Informatica
by
rajeshsharma
(
23.9k
points)
informatica-dimension-table
dimension-table
0
votes
Q: Is it possible for a table to have more than one foreign key in SQL?
asked
Jul 10, 2020
in
Sql
by
Robindeniel
(
20.8k
points)
#foreign-key
#sql-foreign-key
0
votes
Q: What are fact tables and dimension tables in OLAP?
asked
Jun 13
in
Sql
by
rahuljain1
(
6.5k
points)
olapdimensiontables
0
votes
Q: A bar chart can be prepared by placing a dimension on the Rows shelf and a measure on the Columns shelf, or vice versa.
asked
Jul 25, 2021
in
Tableau The Sequel
by
SakshiSharma
(
32.2k
points)
bar-chart
tableau-chart
0
votes
Q: ________ is the ability to craft customized views of dimension columns and measures.
asked
Apr 11, 2021
in
Birst
by
Robindeniel
(
20.8k
points)
birst-interview-questions
birst-mcq-questions
birst-questions-answers
birst-cache
cache-birst
birst-compiler
+1
vote
Q: Do a MongoDB database support foreign-key and primary-key relationship in MongoDB?
asked
May 18, 2020
in
MongoDB
by
SakshiSharma
(
32.2k
points)
#mongodb-foreign-key
0
votes
Q: Describe different methods to load dimension tables?
asked
Jun 6, 2021
in
Informatica
by
rajeshsharma
(
23.9k
points)
informatica
informatica-dimension-tables
dimention-tables
load-dimension
0
votes
Q: What does role playing dimension mean?
asked
Dec 22, 2020
in
Informatica
by
SakshiSharma
(
32.2k
points)
#dimension-mean
0
votes
Q: What is a foreign key of a database?
asked
Jun 12
in
Sql
by
Robin
(
14.6k
points)
foreignkey
0
votes
Q: Which statement is false for a FOREIGN KEY constraint?
asked
Dec 15, 2020
in
Sql
by
SakshiSharma
(
32.2k
points)
#foreign-key
#foreign-key-constraint
0
votes
Q: What is a Foreign Key?
asked
Dec 13, 2020
in
Sql
by
SakshiSharma
(
32.2k
points)
#foreign-key
#sql-foreign
0
votes
Q: What is a foreign key in DBMS?
asked
Apr 2, 2020
in
DBMS
by
rajeshsharma
(
23.9k
points)
#dbms-foriegn-key
...
