Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
kesavagopalam123
Contributor
Contributor

I need to connect the dimension table to fact table in star schema but there is no common fields , how can I connect ?

 
Labels (1)
4 Replies
BrunPierre
Partner - Master II
Partner - Master II

Each dimensional table needs to include a primary key that corresponds to a foreign key in the fact table. As a rule, each foreign key of the fact table must have its counterpart in a dimension table.

This could be addressed by the use of composite keys. They're resultants of combining two or more columns in a table, which can be used to uniquely identify each row in a table. But do not guarantee uniqueness when taken individually.

Mark_Little
Luminary
Luminary

@kesavagopalam123 

You would need to have some common field to be able to connect it. Maybe if you share some example data and more detail people maybe able to assist

 

Mark

marcus_sommer

In addition to the suggestion to combine multiple fields within a composite key you may also need some transformation to your fields, like converting strings to a number, combining date + time to a timestamp or to reverse the logic by splitting the parts, creating a date per makedate(year, month) or reverse and various other stuff - quite probably there are such possibilities.

- Marcus

kesavagopalam123
Contributor
Contributor
Author