Can you please tell me how to load the data afterwards. Should I do load the update dataset first or insert one first? And what should be the key columns while inserting into the dimension??
I have one query on change code filter after CDC stage. If I filter change_code=3 for one flow and no filter in another flow, what type of records will pass to the flow without any filter? Please clarify.
compare previous and current records in first transfer itself (stage variables) to identify adds and changes so that there is no need for cdc stage at all, which saves lot of run time.
Datastage certification courses and practice exam are now available at our website. Check below for details and special offers - knowstar.org/dscertification.html
Thanks for your positive feedback. For more Datastage training videos, visit - th-cam.com/play/PL2-GO-f-XvjBEaLudLM_gJ2hDWpKsF6XV.html www.knowstar.co.in
Get certified! Get ahead in your career! Check out our Datastage online course
www.knowstar.org/dscertification.html
Extremely satisfying and neat video explaining crisp details.
Thank you.
Can you please tell me how to load the data afterwards. Should I do load the update dataset first or insert one first? And what should be the key columns while inserting into the dimension??
Crystal clear explanation. Tq
Glad it was helpful
I have one query on change code filter after CDC stage. If I filter change_code=3 for one flow and no filter in another flow, what type of records will pass to the flow without any filter? Please clarify.
Why are we using lookup for dp_id? Dont we have Dep id in source stage and we can just pull that columm? Please reply
compare previous and current records in first transfer itself (stage variables) to identify adds and changes so that there is no need for cdc stage at all, which saves lot of run time.
Datastage certification courses and practice exam are now available at our website.
Check below for details and special offers -
knowstar.org/dscertification.html
Thank you for uploading this video
Thanks for your positive feedback.
Hi Anil, if you have implemented this do let me know did it worked or not. I tried to implement this but getting incorrect results.
What is confirmed dimensions
Hi, Excellent Video , can you provide the sequential files ?
Madam, can you pls share me the steps scd2 with out cdc stage if you have.
Very informative
Thank you for your positive feedback.
Great Video, thank you
Thanks for your positive feedback. For more Datastage training videos, visit - th-cam.com/play/PL2-GO-f-XvjBEaLudLM_gJ2hDWpKsF6XV.html
www.knowstar.co.in
Y u have used joiner stage y don't go for cdc stage directly if u want check new r update record,?
initial join and transformer stages are not needed..the logic could have been achieved directly in last transformer..
Hi Sathish, I have some doubts in datastage could you please help me
not clear at copy delete edit