what log level have you set during execution of scenario. increase upto log level 5 and expand the log in operator navigator.
you can check each step over there
Yes , I put it as level5 , and When I am checking in the operator 'Load data' step is running ,My worry it still running at this step only even after loading the data into work table ( C$ table).
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