That would be a Type 2 Change. The example shared above contains a Type 1 example where Historical Information is replaced rather than kept within the history. At the end of the video there is a Type 2 Change Example where you can see record Line Number 6 contains the old record and Line 7 contains the new along with the date stamp. Type 2 changes are easily identified because they will have start and end date columns as well as sometimes a flag if the developer has added one. Look for Timestamps within the output data and it'll help you identify which is which.
THANKS FOR YOUR TIME AND CLEAR EXPLANATION SIR GREAT JOB
thanks for your feedback .. appreciate your time..
simply superb.. Made the points very clear
Thanks for your feedback .. appreciate your time..
Please keep watching and provide your feedback..
Great video!
Thanks man
primary key column is not showing in the destination column to choose it as business key . Any solution pls
You are my favorite! Thank you
Glad to hear .. thanks ..
Quick question!
Can I get for Fact table? If so please provide the link below.
Nice explanation..
Thanks...
thanks for your feedback ..
Very Nice Explanation!
Instablaster...
Hi, I have one question for you, would that be possible to maintain historical data for the PK table?
That would be a Type 2 Change. The example shared above contains a Type 1 example where Historical Information is replaced rather than kept within the history. At the end of the video there is a Type 2 Change Example where you can see record Line Number 6 contains the old record and Line 7 contains the new along with the date stamp. Type 2 changes are easily identified because they will have start and end date columns as well as sometimes a flag if the developer has added one. Look for Timestamps within the output data and it'll help you identify which is which.
Nice
Thanks for your valuable feedback and appreciate your time...
If u get an any error or warning u explain like why v are getting that
Than v can understand..
This startup has the technical expertise to help in the job search "www.bakejobs.com/experts/"
Nice
Nice
Thanks for your feedback .. appreciate your time..