Datastage tutorial at KnowStar - Lookup , Range Lookup

This is a training video on how to use lookup and range lookup in Datastage.
Send an email to [e-mail]
Visit us at knowstar.org/
Get certified! Check out our Datastage online course
www.knowstar.or...

[@LearnatKnowstar]

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

[@gurucharan8263]

Kudos to the detailed explanation. Thankyou 🙏

[@LearnatKnowstar]

Thank you

[@sanjaydabra]

Excellent video and very good understanding.....keep it up !

[@geetapalki8633]

Nice presentation..Thank you..

[@bose998]

Useful video for me 👍. Thank you.

[@LearnatKnowstar]

Thank you !

[@SomuSomnath-k6t]

Hi Mam,
My Question is why to use ENTIRE Partition in Lookup Stage. Why can't we use HASH Partition in lookup stage. Please provide me some information about this.
Thank you.

[@renukamatham297]

Select column from table a join table b on column1= column2 or decimal(column1)=column2 where condition........
If it's join on one condition will do...but I have to check for another condition like or condition2....
Can we implement this query in Datastage using join or lookup

[@LearnatKnowstar]

You can try using the Case function in SQL to write an appropriate query.
In datastage, you can perform separate joins based on the two conditions and then use a transformer to check if the records matched on any of the two join conditions.

[@shivakumarmelligeri4831]

Range Lookup 31:20.

[@gorantlasrinivas3662]

nice video to good understand, but in this video you didn't see the how to work the without key columns.

[@aritrabanerjee645]

what will happen if we specify a condition and set continue in condition not met property?
will it include the record and set it as NULL?

[@LearnatKnowstar]

Yes. It will set the lookup column value as NULL.

[@jeffrey0208]

😮😊good

[@LearnatKnowstar]

Thank you

[@brikali50]

Dear, Actually I got an issue while using "Lookup file set" As a reference link. It is recommanded to use "lookup file set " as a reference link for the lookup instead the sequentiel file and while trying to do so , I am facing an issue which is the no possibilty to link to two keys ; While trying to drag and drop the column, I got the following error message : "Key expression cannot be set to an individual column for Lookup file set reference. Check range checkbox and then edit the expression by double clicking on expression box or use the contect menu". What should I do in order to perform that join ? thank you

[@binduabraham5487]

You have mentioned condition as 9999 ,there is one record having deptid = 9999,so. Only 1 record should be. Considered for lookup ..right?

[@nagiyadav9642]

@@binduabraham5487 hi

[@mbkamath3720]

Hw to decide whethr to use seq file stage or dataset

[@ranjithredladinne7844]

if you want to read data with in datastage then you go for dataset .Instead of this if you want to read data out of datastage from ñote pad or word or text reading platform then you go for sequential file..