• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Error when use tOracleSCD to generate Surrogate Key and SCD2

#1 2012-05-04 22:11:05

rcn0706
Member
Registered: 2012-04-23
Posts: 32

Error when use tOracleSCD to generate Surrogate Key and SCD2

Tags: [error]

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

#2 2012-05-07 07:13:18

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Error when use tOracleSCD to generate Surrogate Key and SCD2

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


Only Paranoid Survive.

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Error when use tOracleSCD to generate Surrogate Key and SCD2

Board footer

Powered by FluxBB