You are not logged in.
Announcement
Unanswered posts
|
Pages: 1

I am absolutely new to Talend. I am trying to get input from a delimited files and input to a database table, generate surrogate key and track changes using SCD type 2
My Source shema has 5 columns:
PERSON_SID
FIRST
LAST
STATE
UPDATE_DATE
My Target schema has 7 columns:
PERSON_SID
FIRST
LAST
STATE
UPDATE_DATE
SCD_START
SCD_END
tFileInputDelimited_1 --->tMap_1---->tOracleSCD_1----OnComponentOk-->tOracleCommit_1
In SCD editor i put typed PERSON_ID as the surrogate key, creation as Auto increment, Type 2 fields has FIRST,LAST,STATE
However, I keep getting the error on tOracleSCD_1 "Unknown value in the list / Value set not supported by the component"
Any idea why? Any help would be greatly appreciated.
Thanks.
Offline

Hi
Welcome to Talend Community!
Unfortunately you encounter a bug which has been committed [TDI-20675].
You will see that the fixed versions are 5.0.3, 5.1.1.
Sorry for this.
Regards,
Pedro
Offline
Pages: 1