Hi everyone ,
i am trying to implement scd2with Sk.
database---->transformer---->target database(update)
^ \
| \
| target database(insert)
target database
while i am executing , the job is abortING.I AM GETTING AN ERROR AS
scd2san..xfm1: |scd2san..ODBC_15.update: DSD.BCIOpenW call to SQLPrepare failed.
SELECT "sid","storeid","name","city","state","cid","startdate","enddate" FROM TSXI0."sandup3"
SQLSTATE=S0022, DBMS.CODE=904
[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00904: "enddate": invalid identifier|
I had given the column name for enddate and had given right format as in yyyy-mm-dd but still not able to get the result.if i replace the update and insert databases with the flat file , and then insert/update the data from flat file to database in a new job ,its working fine.I was wondering why its not working if we implement which is in the above figure.can anyone please give valuable suggestions or my approach is wrong .
thanks in advance.
scd2 fatal error
Moderators: chulett, rschirm, roy
So... in other words... the exact same problem you've already posted about. Why did you feel the need to start over again?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers