Scenario:
Let's say we get our reference data in a flat file and before we load data from source to destination we have to match with our reference data. If data matches we will load otherwise ignore the non matching source data.What we will learn in this video
- How to read data from Flat File Source and Load into Memory by using Cache Transformation
- How to use Cache Transformation Connection Manager in Lookup Transformation
- How to Read Source Data from SQL Table and Compare by using lookup Transformation and load only matching records to destination in SSIS Package
- How to use OLE DB Destination in SSIS Package
Use to use Cache Transformation in SSIS Package - SSIS Tutorial
Nice blog and valuable for all people. Thank you for posting this.
ReplyDeleteInformatica MDM Training in Chennai
Informatica mdm training
german classes
Best IELTS Coaching in Chennai
learn Japanese in Chennai
IoT Training in Chennai
content writing course in chennai
Informatica MDM Training in Porur
Informatica MDM Training in Adyar
I think SSIS is actually the best and useful tool to solve complex IT problems.SSIS is the only tool to look forward.
ReplyDeleteSSIS Upsert