on 07-28-2017 5:28 AM
Hi ,
Is it possible to use a store procedure to read from a CV and then populate the result into a table which will have same structure as the CV with certain filters applied?
Then I would like to use external ETL tool to call this store procedure on daily basis.
If you someone has done this before, can you please share the details as to how it is done?
Thanks,
DJ
Hi Lars,
Thanks for your response. Actually the target table will have less number of columns. Is there any online resource available on scheduling SP using XS Scheduler?
Thanks,
DJ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, that's possible.
Why do you want to duplicate data, though?
As for the scheduling of such a stored procedure, you could use the XS scheduler in SAP HANA.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.