![]() When property is set to delete the source data which is already present in the target will be deleted from the target table.For updating of data primary key needs to be defined in the target table. When the property is set to update, the target data will be updated by the source data.When this property is set to insert, the source data will be marked to be inserted.For example, you can define that the source record should be inserted or deleted from the target. This property allows you to define how the source data affects the target table. Step 4) In properties tab, it will show the properties of the session Step 3) Inside the “Edit Task” window clicks on the properties tab. Step 2) Double click on the session icon inside Task Developer to open edit task window. ![]() ![]() Step 1) Open the session “s_m_emp_emp_target” in task developer, which we created in the earlier tutorial. In this section, we will discuss the following important properties of the session. You can also override mapping properties in the session properties. Using the properties of the session you can configure various characteristics of the session like pre and post SQL scripts, log file name and path, memory properties, etc. Session Log File Name & Session Log File directory.How to Make Treat source rows as – Delete.When you create a session in task developer, then it can be reused, but when you create a session in workflow designer, then it is non-reusable.Ī reusable session can be added to multiple workflows. To execute a session task, it must be added to a workflow.Ī session can be a reusable object or non-reusable. Any session you create must have a mapping associated with it.Ī session can have a single mapping at a time and once assigned, it cannot be changed. Session property is a set of instructions that instructs Informatica how and when to move the data from source to targets.Ī session property is a task, just like other tasks that we create in workflow manager.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |