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?
0
votes
asked
Jun 6, 2021
in
Informatica
by
rajeshsharma
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
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
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
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, 2023
in
Netezza
by
rajeshsharma
netezza-coloumn
0
votes
Q: Define Dimension Table in informatica
asked
Jun 6, 2021
in
Informatica
by
rajeshsharma
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
#foreign-key
#sql-foreign-key
0
votes
Q: What are fact tables and dimension tables in OLAP?
asked
Jun 13, 2023
in
Sql
by
rahuljain1
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
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
birst-interview-questions
birst-mcq-questions
birst-questions-answers
birst-cache
cache-birst
birst-compiler
0
votes
Q: Describe different methods to load dimension tables?
asked
Jun 6, 2021
in
Informatica
by
rajeshsharma
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
#dimension-mean
...
