The requirement is to process only half of the records from the source table. To do this we need to calculate the total number of rows (TOTAL-COUNT) in the source table and then assign ROW-COUNT and exclude the rows if the ROW-COUNT <= (TOTAL-COUNT/2).
Let’s design the mapping for this. We need below transformations to execute this logic.
Expression : To assign the row count Aggregator : To Calculate the total input count (maximum (Row Count)) Joiner : To Join Aggregator and Expression Filter : To process only half of the records