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.
