I have requirement like below
Before File:
Key Non_Key
1 a
2 b
3 c
After File:
Key Non_Key
1 a
2 d
4 e
Then how many records i will get after ChangeCapture stage and what is the value of the "ChangeCode()" field ?
Need help in Change Capture stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Thu Aug 12, 2010 12:07 am
-
- Participant
- Posts: 6
- Joined: Wed Mar 09, 2005 9:35 am
Re: Need help in Change Capture stage
You can easily get the answer you want by looking at the developers guide
You should get 4 rows
Key Non_Key Change code
1 a 0 (Copy)
2 d 3 (Edit)
3 c 2 (Delete)
4 e 1 (Insert)
You can make the change codes whatever you want. Above are defaults.
You should get 4 rows
Key Non_Key Change code
1 a 0 (Copy)
2 d 3 (Edit)
3 c 2 (Delete)
4 e 1 (Insert)
You can make the change codes whatever you want. Above are defaults.
-
- Participant
- Posts: 26
- Joined: Thu Aug 12, 2010 12:07 am