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 solution.
All records get rejected in CDC stage Job.
Moderators: chulett, rschirm, roy
All records get rejected in CDC stage Job.
Thanks,
Surya
Surya
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: All records get rejected in CDC stage Job.
Please share the warning message
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_KEY": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,0]": Possible precision limitation.
Sourcefields: When checking operator: When binding output schema variable "outputData": When binding output interface field "SYS_KEY" to field "SYS_KEY": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted.
Are these warnings the reason for rejecting the records, In the performance statistics I see that all the records pass to the target but they are not getting loaded.
Thanks
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_KEY": Implicit conversion from source type "decimal[38,10]" to result type "decimal[38,0]": Possible precision limitation.
Sourcefields: When checking operator: When binding output schema variable "outputData": When binding output interface field "SYS_KEY" to field "SYS_KEY": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted.
Are these warnings the reason for rejecting the records, In the performance statistics I see that all the records pass to the target but they are not getting loaded.
Thanks
Thanks,
Surya
Surya
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 this the reason for rejecting records?
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 this the reason for rejecting records?
Thanks,
Surya
Surya
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Used drop for all the records where there is no lookup for the same field but still the records get rejected so that is not the case.
In the target I used peekstage where I can see all the records but for some reason they are not loading into the oracle table(oracle enterprise stage).
Please suggest any changes
Thanks
In the target I used peekstage where I can see all the records but for some reason they are not loading into the oracle table(oracle enterprise stage).
Please suggest any changes
Thanks
Thanks,
Surya
Surya