on 08-14-2014 3:36 PM
Hello,
My source is csv files and I need to load these source files into HANA after doing some Transformations based on multiple validations (for example , based on grade, some new column has to be populated with some relevant hikes i.e. need to use if/else logic, case logic, either insert or update in target table …etc. This validation should be done for each and every row).
Assume some of the validations not possible through BODS and I need to implement this logic in HANA scripting (through procedures).
I know HANA supports two kinds of writing scripts i.e. HANA standard sql statements and CE_functions and I’ve heard from HANA documentation that CE functions gives more performance than standard sql statements and we should not mix together in a single block of code.
Please let me know which scenario should I go for? (I doubt if we can do all the functionalities using CE functions?
I am looking forward to your reply.
Thanks,
Sree
Hi All,
Was my question not clear ??
Thanks,
sree
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Much awaited reply.
Thanks a lot Jain !
But just one more point to bring out, if some of requirements can be done through both CE functions and Scripting, and some are possible through only scripting then we need to go for sql scripting only ..as we are not supposed to bring both the coding standards together, results in performance issues. ( Even your diagram shows either CE functions or Use SQL)
am i right?
Thanks,
Sree
Hi Sreedhar,
Yes you are right. Never mix up code with CE functions and SQL script. If all your requirements can be done with CE functions, then go with CE functions. If atleast one function cannot be done with CE, change entire code to SQL scripting only. Reason behind this is, if we mix CE and SQL sqripts, at execution time data and control has to hop between different engines and thereby degrades performance of the query.
Hope this clears your doubt.
Regards,
Chandu.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.