AnsweredAssumed Answered

Loading a fact table from operational database

Question asked by Victorien DELANGUE on May 13, 2019
Latest reply on May 15, 2019 by David Carvalho

Hello there, I know there is a lot of stuff about loading a fact table here but I don't really find answers that fit my needs. I have created a data warehouse on PostgreSQL with dimension tables already populated and fact tables in which I want to insert facts from an operational database. For that, I have extracted my data from my operational database but now I need to link the facts with the right dimension ids each time and I don't really see how to do it with the dimension lookup stuff. Can you help me with that? Thanks, Victorien