In Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how do I do this? - ETL
In Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how do I do this.
- A mapping variable and a filtered transformation could solve.
The process is :
- Create a mapping variable. Assign value 0 to it as default value
- During the first fun, the source will have a sequence number (seq num). Otherwise, use seq gen to have a unique sorted record
- Specify an expression
var_max_filter = @@map_variable + 2 and var_min_filter = @@map_variable – 2
- Put the filter on the ' seq_column <=var_filter and seq_column>=var_min_filter ' in the filtered transformation