DSXchange

I am not passing the change code to the database.


Using peekstage I see a improper lookup between two fields of tables.

After lookup the field of one table is giving Null records rather than data in it.


This might be the problem for rejecting records.

Used a peek stage to see the records in the place of Insert Table. As there are 2 nodes in the project I see 2 peeks in the log of Director and there I can see the records in one peek and in the other peek I see that the key which is used as changekey in Change capture has 0 in all the records. Is t...

I do not see any errors in the log except some warnings about the implicit conversion between datatypes. Below are some of them Sourcefields: When checking operator: When binding output schema variable "outputData": When binding output interface field "SYS_KEY" to field "SYS...

I am implementing SCD2 using Change capture and at the end there are two targets one being the Insert and other for Update. The jobs runs well but at the last all the records get rejected in the Oracle enterprise stage which is used for only Insert. Please suggest me any changes required for the sol...

It changes twice a month. Using CDC I developed a job for scd2. The fields from the source are transformed and then passed to the CDC stage and then the fields from the target are also passed to CDC stage. Here I have a small issue with the begindate and enddate from the target. These two fields are...

Sure, will do CDC.

Hello, I need to develop a job to implement SCD type 2 and the version is 7.5.2 which is the best way to do it? I have 2 options 1) lookup and transformer , collecting rejected records and upd, ins 2) using change data capture and transformer. please let me know...which would be the better option? T...

That helps!!


Thanks Michael

Hello, We had 8.0.1 version of IS earlier, and now IS 8.5 All the job have been migrated from 8.0.1 to 8.5 Nothing changed everything is the same in the job but cannot connect to the DB which is DB2. I used DSDB2PX stage for the job to connect DB2. do I need to do any specific changes to the stage a...

I used ODBC connector PX to insert and update records. My job has around 30 ODBC connectors for the update and insert When I run the job, to some part of it the records are updated and inserted in the tables but If all of a sudden the job aborts at some place. Then some of the tables are loaded and ...

Thanks for the Information.


Tried the service with a simple job did not work, so I thought there is no issue with the job.

So removed the application in the ISD and started a new project-application-operation........now it works...great.

Probably the earlier application in ISD may had some issue.

I mean the job which has the sequential files as source and target. I changed the source and target of the above job to WISD input and WISD output and then invoked as a service. I received the output when it was a batch job but when that was a service job I did not receive any response. Tried to tes...

we have a job in the designer which is invoked as a service. First I tried to run the job using sequential file as source and target, the job was fine as received the expected output. But the same job when invoked as service returns nothing but seems to be running in the director. I tried to test it...

Thanks ernie.....

Will give a try

All the jobs in 8.5 have been exported to my machine and then I tried to import them into 8.0.1 But a window opens which says:- C:\Documents & Settings\KSK\ABC\ABN_NAME doesnot appear to be datastage export file or is from incompatible release. A Valid Datastage export file is expected to be in ...