Capture changes at file level
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Wed Mar 17, 2010 11:05 am
Capture changes at file level
The requirement is to capture changes at sequential file level (about 50 columns). Any column may have changes. Is there a way to capture the changes (insert, delete, update indicator) without specifying all 50 columns as keys in Change Capture stage?
-
- Participant
- Posts: 43
- Joined: Thu May 29, 2008 8:41 pm
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
Re: Capture changes at file level
You need a set of keys, which will uniquely identify a row and then the stage will compare all the values of the other fields inside a Change capture stage as far as I know. You might want to consider using the "Difference" stage.reachsam11 wrote:The requirement is to capture changes at sequential file level (about 50 columns). Any column may have changes. Is there a way to capture the changes (insert, delete, update indicator) without specifying all 50 columns as keys in Change Capture stage?
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
Experience is what you get when you didn't get what you wanted
Re: Capture changes at file level
We solved this problem in 7.5.2 by writing a build op that did the comparisons. Our requirement was given a set of data in the format of
produce a row of data for each column changed based on keys. The produced row was of the format
We send it a sorted data set and it produces the rows we need.
Code: Select all
any number of keys|any number of data columns|row stats such as update date and update user,
Code: Select all
keys|old value|new value|row stats
Robert Hale
TSYS Acquiring Solutions
TSYS Acquiring Solutions
-
- Participant
- Posts: 26
- Joined: Wed Mar 17, 2010 11:05 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Set the Change Mode property to Explicit Keys, All Values
Use a Difference stage with All non-Key Columns are Values or a Compare stage (depending precisely on the form of output you need)
Use a Difference stage with All non-Key Columns are Values or a Compare stage (depending precisely on the form of output you need)
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.
-
- Participant
- Posts: 26
- Joined: Wed Mar 17, 2010 11:05 am