I am loading the data from flat file to Oracle DB.
When I check the operator it is always running at the step load data and is unable to go to next stpe( Insert new records) , But when I check thework table all the data loaded into work table( C$ Table) . Is there any way to check the log at what step my scenario is running?
Could you put some more information on
1. Staging Area : Is it different from Target ?: The standard Sunopsis Memory Engine or In-memory engine are too slow
2. What are the mappings (any lookups/joins that are performed) and where are they performed, Source, Staging or Target ? (High volume look ups or joins can decide the time depending on where they are implemented)
3. LKM : Try using Bulk loading or some specific technology LKMs instead of generic