Slowly Changing Dimension on Vertica

Anonymous — Thu, 29 Aug 2019 02:58:34 GMT

I am having an issue using the tVerticaSCD component. This component is generating single row insert statements using a values list rather than a table to table (select from source, insert/merge into target), which would be very much preferable.

My current process flow is as follows:

tDBInput (Vertica source table) > tMap (used to map variable values to a few columns) > tDBSCD(Vertica)(target Vertica table)

I was looking into using the tETLVerticaInput and tETLVerticaMap components instead to see if that allows for in database processing, but aparently they are not compatible with the tVerticaSCD component. The only output option I have for the tETLVerticaMap component is the tETLVerticaOutput component.

Does anyone know of a solution to accomplish a table to table SCD load? I will be using this pattern for a lot of tables, so the less manual configuration the better, but I would appreciate any and all suggestions.

I'm currently on TOSDI 7.1.1

Re: Slowly Changing Dimension on Vertica

Anonymous — Mon, 09 Sep 2019 04:29:02 GMT

Hello,

So far, there is no tVerticaSCDELT component.

Feel free to vote for this new feature jira issue:https://jira.talendforge.org/browse/TDI-18452.

In this way, its ranking will get updated.

Best regards

Sabrina

Re: Slowly Changing Dimension on Vertica

Anonymous — Mon, 09 Sep 2019 04:34:13 GMT

I am not given the option to vote for this issue, presumably because it has been rejected.

topic Re: Slowly Changing Dimension on Vertica in Talend Studio

Slowly Changing Dimension on Vertica

Re: Slowly Changing Dimension on Vertica

Re: Slowly Changing Dimension on Vertica