Question when using debugger

[jisoo23]

Hello all,

I have a mapping that has a source/source qualifier that's basically empty (it's just there so I can start the mapping to do other things like lookups to get the relevant info). When I turn the debugger on, things look normal but when I step to the next instance, it gives me this warning:

Response from the server: Session completed successfully. Last chance to look at target data. Debugger will shut down when we continue.


Obviously I want to be able to progress on through the mapping. The source column is very simple, just a string datatype with nothing sent over. The next step is an expression transformation where the source column is linked to a column with the same name. But it's only there to make sure the mapping has continuity. There are other fields there that actually start the real work behind the mapping. Does anyone have any ideas why it shuts down before reaching the transformation object?

Thanks,
Jisoo23

 

[Dagon]

It sounds like your input soure is not returning any rows. If no rows are read, then obviously there is nothing to pass through the rest of the mapping and the debugger will terminate straightaway. You should amend you source to return a single row. If you're using Oracle, you could do this using something like:

select 1 from dual