CODEWITHSUNDEEP
pentahoetlbusiness-intelligencekettledatamart
Zakaria Belghiti
Zakaria Belghiti

Reputation: 551

retrieving technical keys to fact table in PDI

How can I retrieve the technical keys from the dimensions to the fact table in Pentaho Kettle, only the new ones that haven't been loaded yet, I tried to use Dimension Lookup but it didn't worked.

This is my schema :

Star Schema

I've already created transformations that loads the dimensions directly from a csv file and also a job that executes these transformations in parallel.

Upvotes: 1

Views: 223

Answers (1)

user13262794
user13262794

Reputation: 29

Populating a fact table should be the same as populating a dimension table? You're looking for a step that can convert incoming fields into an sql INSERT query? I've used "Table output" to populate more than 40 fact tables. Works like a charm. If you need something more fancy, "Execute SQL script" works good too.

Upvotes: 0

Related Questions