Advanced ETL Interview Questions - I have ten records in my source system but I need to load only 2 records to the target for each run. How do I do this?
ETL (extract, transform, and load) Testing Interview Questions
(Continued from previous question...)
Advanced ETL Interview Questions - I have ten records in my source system but I need to load only 2 records to the target for each run. How do I do this?
Creating a mapping variable and a filtered transformation is one possible way to solve this issue. First, start by creating a mapping variable. This is usually assigned a default variable of zero. You might need to generate a sequence in order to have the specifically sorted record you require. From there you structure your expression and turn on your filters.
(Continued on next question...)
Other Interview Questions
|