tDBSCD type 2 from tFileInputDelimited

[Anonymous]

Hi,

My problem is that my job simply does not end: I get no error code, no pop-up, it just freezes like this screenshot and the destination table never fills up:

However, when I remove the tDBSCD_1 component, it works fine and the tLogRow_1 displays the result correctly.

For a better understanding of my problem, here is the tMap :

Here is the tDBSCD_1 component info:

And here is the tDBSCD_1 editor screen:

As you can see, all the fields used in the SCD are present in the destination table in MySQL:

Does any1 have any idea why the process freezes at the end? I tried using "tDBClose", "tDBCommit" with the "Close Connection" checkbox marked, it still doesn't work. Thank you!

[Anonymous · Accepted solution]

Ok, I fixed it. In my SCD component editor, in the "Surrogate keys" section, I changed the option of the "creation" field and put it to "Table max + 1". Once that was done, the run completed fully, however, for it to persist on the destination table, I had to change the tDBClose component too and put a tDBCommit instead. Here you go, cheers!