Datastage tutorial - Example using Join , Aggregator stage - Learn at KnowStar

[@LearnatKnowstar]

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

[@TheBex2007]

I have seen several Datastage TH-cam tutorial, you are the top. Coherent and you touch very important topics, especially your interview questions and answers. Keep up the good work.

[@LearnatKnowstar]

Thank you so much! Please keep supporting our channel by liking, sharing, and subscribing!

[@HarishKumar-fx3cc]

@@LearnatKnowstar Could you add some serial order in videos?

[@tanyasinha2897]

Can you please tell me how to insert record form a table to another table with one unique column .when records are when fetched from
Source table and inserted to target table ,it should generate a sequence for one column like 1,2,3,4 .and when it job run next day it should increment the value from max value.

[@karthickean-c3z]

may i know the purpose of key type

[@shashirachakonda6330]

If you use lookup stage after join stage, it will be more simpler.

[@saddikiLatifa]

Bonjour, c'est possible d'activer les sous titre en français svvvvp??

[@vinaykumarhiremath1889]

Hello,
Here, If I want to do count distinct instead of count, how do we do that?
Select ID, place, type, count(distinct ID) as ID_cnt , sum(nvl(amt, 0)) as amt_sum, count(distinct type) as type_cnt from table1
Group by ID, place, type

[@Priyo108]

Good example to understand the stages. It could have been more optimized by moving the lookup towards end.

[@sandipansarkar7990]

Instead of lookup we can use the product link to the join itself to avoid complexity... anyways very good example

[@sergesare451]

Hi everyone.
Someone can tell me where to download the input file to practice this unit? thank a lot.

[@drbritto]

You just helped me ! Thanks a lot !

[@LearnatKnowstar]

Thank you for your comment!

[@neigdias]

very good example

[@mirzafarazbaig8945]

thanks a lot. keep up the good work.

[@LearnatKnowstar]

Thank you for your positive feedback.
Do not forget to SUBSCRIBE to our TH-cam channel for more such videos.

[@angelioo1392]

thanks a lot

[@srilatha3103]

Thanks mam

[@sujathachidambaram4548]

Very useful

[@LearnatKnowstar]

Thanks for your positive feedback!