Solved SCD and incremental update on a same table

Hi,

In a first time, I wish a happy new year to the Stambia community.

We are starting the modification of our mapping to replace the incremental update by the SCD.
I know how it works: I have to define the "Slowly Changing Dimension Mode" on each column of the table.

My problem is, after the SCD mapping, I have another mapping which updates the same table. For this mapping, I have to use the incremental update.
But because my medatada is set up for SCD and the template automatically determinates the SCD/incremental mode, I cannot use the incremental update anymore.
How can I do that?

I sum up:
- One table set up for SCD,
- A first alimentation on SCD,
- A second alimentation on incremental update --> impossible

I thought to create a second metadata to duplicate the same table, but I want to avoid maintaining a same object twice (jdbc / login / column / etc.).

Thanks.

Hi,

Happy new Year to you too!

You don't necessary have to create a second metadata. The same table can be added multiple times on the same metadata:



Here both are pointing to the same physical table (The same Physical Name is defined on each of them).
You can easily do this with copy/paste the table on the same schema.

And then you can configure one with scd, one without. So you don't have to create a second metadata.

Is this solution acceptable for you ?

Yes, it is actually the easiest way to do what I want...
(I'm wondering why I was looking for a difficult solution )
Thank you Cyril!