MS SQL to ABAP Proxy (BW)
I have a scenario where i call a stored procedure to MS SQL DB which returns me a huge resultset of 17.4 MB size. I also have to convert 2 fields before i send it to BW via ABAP Proxy.
I do a lookup to another conversion db for converting thoe 2 fields.
Please suggest me how best i can handle such a huge resultset and optimize the lookup.