0

I'm filling my data warehouse's table (MySQL) after some transformations with spoon. However, my dimension table is filled and I've to fill my fact table from a CSV file. So, when I try doing it, kettle warn me there are some records that violate foreign key constraint and the transformation is aborted. This is caused because not all foreign keys in my CSV appear in my dimension tables. How can I control if a foreign key is present in the dimension table which refers by kettle?

JulianHarty
  • 3,178
  • 3
  • 32
  • 46
F. Petrulio
  • 95
  • 2
  • 9
  • 1
    you need to stage the data in another table first and then insert only records into the table that have a relationship with your dimension table, or create extra dimensions for fact data that are missing. - this is referential integrity being enforced so it is expected behaviour – jimmy8ball Jul 07 '17 at 08:27
  • Foreign keys feature already impelemented in database. Much easier to use it. Load data in tables then implement merging logic on database level – simar Jul 18 '17 at 09:55

0 Answers0