I want to convert n rows from source to single column. I have used row generation but it's giving pagable cache error : no space left in device when data is huge.Any solutions will be welcomed.
please can you add some more details beside that high level description. Information like in what area you are working, what you are exactly doing (with examples), ... would be helpful for the people to understand your issue. Also if you say "data is huge" please give more details, what means huge for you (numer of data records) and what system sizing you have (because huge can mean just huge, because your system is maybe not correctly sized for instance).
As I mentioned, I am working in CPI- DS team. We are trying to take data from ibp and put it in fileserver in required format.
The scenario is for a material we have to take 56 key figure columns which are required in Target file.
The requirement is we need all keyfigure in single column. So, we put row generation to make all keyfigure in a single column.
Now,the problem here is it will generate 56 rows for a single material. It is breaking after running more than 48 months. I couldn't find the exact reason why it is giving pagable cache error: no space left on device. Any solution/suggestion to this problem ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.