Any way to avoid these warnings? I like using the Difference stage, it is more flexible then the Data Capture stage as it supports non matching columns, but all these warnings is breaking my 50 warning limit. This is version 7.1 so I do not have the message handler.Difference_1:When checking operator: Dropping component "fielda" because of prior component with same name
Difference_1:When checking operator: Dropping component "fieldb" because of prior component with same name
Difference_1:When checking operator: Dropping component "fielda" because of prior component with same name
Difference_1:When checking operator: Dropping component "fieldb" because of prior component with same name
Difference_1:When checking operator: Dropping component "fielda" because of prior component with same name
Difference_1:When checking operator: Dropping component "fieldb" because of prior component with same name
Difference stage issues lots of warnings.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Difference stage issues lots of warnings.
When I use the Difference stage I get three warning messages in my log for each column being compared:
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Hi,
this sounds like a lookup stage warnings not a difference stage
never seen such warnings from diff stage
this sounds like a lookup stage warnings not a difference stage
never seen such warnings from diff stage
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Hmmmmm....
I haven't used the difference stage. If you still have this problem on Monday, private message me, and I'll investigate.
Edit: You do know that you can change your warning limit defaults? I would bet that you do know that. Hope you don't have one of those clients that demands 50 warnings "just because Ascential set it that way."
I haven't used the difference stage. If you still have this problem on Monday, private message me, and I'll investigate.
Edit: You do know that you can change your warning limit defaults? I would bet that you do know that. Hope you don't have one of those clients that demands 50 warnings "just because Ascential set it that way."
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Hi,
In EE there is a difference stage.
taking 2, sorted hash partitioned and with same meta data, data setes resulting in a set with the diff column 0-3 indicating no-change,insert,update,delete options (EE developers guide has exact number=meaning info)
In EE there is a difference stage.
taking 2, sorted hash partitioned and with same meta data, data setes resulting in a set with the diff column 0-3 indicating no-change,insert,update,delete options (EE developers guide has exact number=meaning info)
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Enterprise Edition (EE) is a superset of Server Edition. With Server Edition you can create server jobs and job sequences. With Enterprise Edition you can create server jobs, parallel jobs and job sequences.
Enterprise Edition MVS is a superset of Enterprise Edition. With Enterprise Edition MVS you can create mainframe jobs as well.
Enterprise Edition MVS is a superset of Enterprise Edition. With Enterprise Edition MVS you can create mainframe jobs as well.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
I have sent a simple difference stage example through to Ascential support to get the final word. I am calling the job from a Sequence job so I cannot get around the 50 warning limit.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
I found a message in the Orchestrate Operators Reference that did not make it into the DataStage documentation that suggests we should not use this stage:
I think Difference has a subset of the functionality of Change Data Capture. I thought it was a bit more flexible in the selection of of non value fields but closer inspection of the Orchestrate doco reveals the behaviour to be the same.The diff operator has been superseded by the changecapture operator. While the diff operator has been retained for backwards compatibility, Ascential recommends that you use the changecapture operator for new development.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Hi,
Good to know Vincent Thanks(asbout the dsiff/change capture).
Iguess that warnlimit thru sequence jobs is another one for the wish list.
Good to know Vincent Thanks(asbout the dsiff/change capture).
Iguess that warnlimit thru sequence jobs is another one for the wish list.
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
I'd forgotten about that, the sequence job passes run time settings through to the child job, so the warning limit is passed through. The number of rows to process is also passed through for called server jobs.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn