|
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
ETL (extract, transform, and load) Testing Interview Questions
(Continued from previous question...)
17. 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
- 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 = @amp;@amp;map_variable + 2 and var_min_filter = @amp;@amp;map_variable – 2
- Put the filter on the ' seq_column <=var_filter and seq_column>=var_min_filter ' in the filtered transformation
(Continued on next question...)
Other Interview Questions
| 