We will add up some country names to this master table. We will also create master table for Country List name it as Country with columns : CountryId, CountryName. So we will take up a Customer Table with columns : CustomerID, CustomerName, CustomerAmount, CustomerAddress, CustomerCountryID, CustomerISActive. Here we will do a simple example to make you understand quickly how LookUp works. Now let's understand same component using real time example that we will do step by step.
Hope you have understood about #LookUp component. So to get this foreign key value we need to use #LookUp component which compares source records with City master table to get matching key values and same can be updated to Customer table. Now if you see in the destination Customer Table we have CustomerCityID which is foreign key and here in the source file we have string type value and for proper insert we need its Foreign key value. And let's say you have a sample source data in this format : "1001 as CustomerID", "Shaam as CustomerName", "R-no 202 - mulund naka as CustomerAddress" & "Mumbai as CustomerCity". It compares source data with existing table dataset and filters matching ones and un-matching ones.įor example let's say you have customer table with columns CusomerID, CustomerName, CustomerAddress,CustomerCityID where CusomerID is a primary key and CustomerCityID foreign key for City Table. LookUp is very useful transformation SSIS component it performs lookup operation by connecting input value with data-table or table dataset columns.
NET training (AngularJS, MVC, ASP.NET, MSBI, Sharepoint and many more) feel free to touch base with us.Ĭoming back to article in today's session we will learn and understand SSIS lookup using an example step by step.
#quetpond + ME we love to deliver quality training and till now we succeeded and want to continue more same in coming future session. I love working with this company simply because it only cares about quality teaching, videos, books, online subscription. ShivPrasad Koirala with a vision to spread tech knowledge. Little About my Company : #Questpond is an e-learning started by Mr. I'm your host Gurunatha.D a simple enthusiastic developer hunt to learn new technologies, learning and working is my passion that i do daily. Hello Friends, #MSBI Learners, welcome to step by step msbi tutorial.
0 kommentar(er)
