40 Fuzzy Lookup Transformation in SSIS
HTML-код
- Опубликовано: 7 сен 2024
- Fuzzy Lookup Transformation in SSIS | How to use the Fuzzy Lookup Transformation in SSIS
Download the file\script used in the Video from below link
drive.google.c...
SSIS Tutorials: • SSIS Tutorials
SSIS real time scenarios examples: • SSIS real time scenari...
SSIS Interview questions and answers: • SSIS Interview questio...
Fuzzy Lookup Transformation in SSIS
What is Fuzzy Lookup transformation in SSIS?
What is difference between Lookup and Fuzzy Lookup in SSIS?
What is Lookup transformation in SSIS with example?
What is fuzzy grouping in SSIS?
Happy Learning.
If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com”
Great videos, keep it up!
Thank you for your support.
hi aqil,you are doing good job.
Thank you so much for your comment.
Hi Aqil, can you join results of fuzzy matching and then do another fuzzy grouping? Like for a dataset, first grouping is address, then next is last name and finally social security. These creates 3 groupings. And how do you combine records that are linked together?
Hi, Your videos are very good, very well explained. Could you please upload video about the difference between fuzzy lookup and fuzzy grouping, example of fuzzy grouping. Thanks
Thanks Mukta for your comment, I will surely upload the video about Fuzzy grouping.
Hi Mukta, I have uploaded a new video on fuzzy grouping.
ruclips.net/video/X1ZhOSbE3oo/видео.html
I hope you will like it.
Thanks.. really appreciate the help
I am subscribe your channel
can you help me how to used not in two component in ssis like
select * from dbo.tblStudent where intStudentId not in(select intStudentId from dbo.tblLibary )
Sorry for replying so late, was a bit busy. You can use Merge Join component where you can use Left Join, so it will return all records from left source and matching records from right source. For non matched records from right source you will get a NULL value, so may be in a derived column transformation you can replace a NULL with some different value and then in Condition Split transformation based on the data returned you can decide if you want to move the matched records to one table and non matched records to another table.
Hi bro can you explain script task regarding particular file need to pic up
Can you explain in detail meaning particular file pic up ? Do you want to get the file path of a file ?
How did u get the similarity, confident columns?
Hi Anil, these columns are returned by Fuzzy Lookup Transformation itself.
Nice Videos. your videos are too good. Can you send me all videos source files. It will be very useful.
Thanks
Hi you can get all the videos here
ruclips.net/video/lkuvvaOntb4/видео.html
Hi sir ,while creating package through ssis not able to run .. plz help me out with that as i m trying whole day ..especially in colum tab
Hi Ankita, what error you are getting while running the package ?
Good
Thanks for your comment.
can you help me how to used not in query in ssis like
select * from dbo.tblStudent where intStudentId not in(select intStudentId from dbo.tblLibary )
Error with Data of 20 million.
What error are you getting ?
@@learnssis thanks for answering me. This is the error:
Error: 2021-12-03 14:36:03.08
Code: 0xC0047022
Source: BUSQUEDA DIFUSA SSIS.Pipeline
Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "FUZZY LKP" (2) failed with error code 0x8000FFFF while processing input "Entrada de busqueda aproximada" (16). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
There may be error messages posted before this with more information about the failure.
@@maihuire11 I think this error is related to Memory, because data is huge, thus you would need more memory to process it.