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.
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
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.
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..
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
Get certified! Get ahead in your career! Check out our Datastage online course
www.knowstar.org/dscertification.html
Kudos to the detailed explanation. Thankyou 🙏
Thank you
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.
Excellent video and very good understanding.....keep it up !
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?
Yes. It will set the lookup column value as NULL.
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
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.
Hw to decide whethr to use seq file stage or dataset
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..
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
You have mentioned condition as 9999 ,there is one record having deptid = 9999,so. Only 1 record should be. Considered for lookup ..right?
@@binduabraham5487 hi
Nice presentation..Thank you..
Useful video for me 👍. Thank you.
Thank you !
nice video to good understand, but in this video you didn't see the how to work the without key columns.
Range Lookup 31:20.
😮😊good
Thank you