June 05, 2005, 03:19 PM
<bobby>capture data change
i am using datamanagment console iway we have done first intial load now we are planning for
incremental load , i have three columns like productnumber line number
productnumber line number
101 3
101 2
101 1
so i want the data change capture on productnumber and linenumber it means if
productnumber is 101 and line number 4 insert it and if productnumber is 101 and line number
3 update it can u plz advice
thanks
Bobby
June 07, 2005, 08:10 PM
newtofocusYou are trying to do a type I slowly chaning dimension.
Simply use the key matching logic in the pre processing option on load object. Select update record if found.
Keep in mind this is going to slow down your processing drastically. I would rather split the file into new and delta and run it twice. Once without pre processing and second with.