Datastage Real time Scenario | Slowly changing dimension | Practice Project | Part 1 - Job Design

[@LearnatKnowstar]

Get certified! Get ahead in your career! Check out our Datastage online course www.knowstar.org/dscertification.html

[@LearnatKnowstar]

This is Part 1 of the tutorial and discusses the step by step job design. Stay tuned for Part 2 to be posted in the next couple of days and will be covering job execution and debugging. I will also post links to all data files used in this tutorial which can be used for practice.

[@dhanrajshunkalwar7098]

Sure

[@kristyowens2284]

Looking forward to Part 2

[@cdprasadait]

Can you help me what is the purpose of JOIN stage. We can directly apply Change Capture and find out insert and update records, later we can use a transformer to update START and END. Can you explain the necessity of JOIN stage? BTW nice explanation and great video. Thanks

[@archanamuduli2098]

Hi Ma'am, It's very helpful. All yours videos are very informative. Could you please create a video on SCD2 without using CDC and SCD stage?

[@LearnatKnowstar]

We will surely plan it soon.

[@archanamuduli2098]

@@LearnatKnowstar Thank you so much Ma'am... :)

[@hazil2008]

Video is stuck at 46.35. The output part of Surrogate key generation is not visible for us. If my understanding is correct, all the columns should be dragged to DSLink32

[@LearnatKnowstar]

Thank you for bringing it to our notice.

[@LearnatKnowstar]

Yes, all columns need to be propagated to the output link.

[@hazil2008]

I must say this is the best channel for any beginners like me learn data stage. Thanks a lot for the videos madame 🔥

[@harikrishnaupputuri3255]

Please Give Dept Table Data Which is used as Look-up Reference

[@lostfrequency89]

Can I connect a database connector to change capture instead of datasets to compare two tables?

[@LearnatKnowstar]

Yes, you can.

[@lostfrequency89]

@@LearnatKnowstar wow thank you for the response. I've learnt so much just watching your videos. Thank you.

[@dhanrajshunkalwar7098]

Thanks for sharing

[@priyankap1105]

Thank you mam

[@shubhamphegade6031]

Video is very informative but voice is not coming good its very distorted...pls fix it if possible in upcoming videos

[@LearnatKnowstar]

Thank you. We will definitely work on your feedback.

[@aishwaryashinde5165]

​​@@LearnatKnowstar is apt config file parameter must be present in every job?

[@kristyowens2284]

Very helpful

[@LearnatKnowstar]

Thank you.

[@anilanche5753]

Hi madam Please help me to migrate job from datastage to iics

[@mbkamath3720]

Wat does dimensional data mean?

[@Lucas-yg8rn]

Poor Anita Brown...Band 0