![]() ![]() These two ports are goanna be just output ports.Add two Ports and Rename them as Insert, Update.Drag all the ports from the Source Qualifier and Look up in to Expression. ![]() We are using the Expression Transformation to separate out the Insert-stuff’s and Update- Stuff’s logically. Finally specify that connection Information (Oracle) and look up policy on multiple mismatches (use last value) in the Properties tab.Next to this we are goanna specify the look up condition empno =empno1.Prior to this Look up transformation has to look at the target table. As usually we are goanna connect Empno column from the Source Qualifier and connect it to look up transformation.Based on the Look up condition it decides whether we need to update, insert, and delete the data from being loaded in to the target table. Look up Transformation: The look Transformation looks the target table and compares the same with the source table. Step 2: here we are goanna see the purpose and usage of all the transformations that we have used in the above mapping. Explanation of each and every Transformation is given below. And in this mapping I’m using lookup, expression, filter, update strategy to drive the purpose. Step 1: Initially in the mapping designer I’m goanna create a mapping as below. So hope u got what I’m trying to do with the above tables: This Method has limited history preservation, and we are goanna use skey as the Primary key here. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |