![]() ![]() In the expression transformation we are adding following ports.Īnd the following are the expressions for the ports. ![]() We are creating a port NEW_FILE_FLAG for the same Now we need to add an EXPRESSION transformation to set a boundary flag for each customer group based on customer's state of residence. After the sorting, we will get the customers grouped together based on customer's state of residence. Let’s build the mapping as we have it in below image, Here we are sorting the data using the SORTER transformation. This is the column based on the file name is dynamically changed. Now let’s add one new column ' FileName' using the ' Add File Name Column' button which is highlighted at the top right corner as shown in the below image. In this article we will see how to split your target file dynamically based on the business rule.įor the demonstration purpose, let’s take a simple business case where we need to split the customer data into multiple files based on the customer residential state.Īs the first step let’s create the flat file definition using Target Designer For example, you may need to generate last month’s top revenue generating customer list, which is split into multiple files based on the customer residence state. ![]() There can be scenarios, where you need to generate multiple flat files using an informatica mapping based on the source data content or some other business rule, from a single data source. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |