I was trying to work with SCD stage and configured it for type 1 functionality.
I created a database sequence which starts with 1 and increments by 1. In the surrogate key tab in the SCD stage, I set
Source Name = <DB sequence Name>
Database Type = Oracle
I keyed in the user name, password and the the server name as well.
Now, after I compile the job and try opening up the SCD stage-> surrogate key tab, I find the Database Type pointing to DB2 and not Oracle!!!
If I try to run the job then it gives me an error
"Library orchdb2op could not be loaded; Could not load "orchdb2op": The specified module could not be found."
And I think the orchdb2op is some library related to DB2 database. I don't know what to do. Could you please help me out with this?
vdr123 wrote:FYI, the 2 duplicate post are not intentional, not sure how it happened. Can admin clean it up?
Probably... unfortunately, it can be a common problem here.
I always check after I post if there's any "delay" in the submit process just in case. I double-check because you can delete your own posts as long as they haven't been replied to so right after it happens is the best time to nuke any extra post(s). Just so you know. For next time.
-craig
"You can never have too many knives" -- Logan Nine Fingers