Can you change the source type single, and select an existing object and check if you are able to see the preview working fine.
Do we see any errors in UI when preview data is clicked?
-> Is the seen only while previewing the data? or the same issue is seen at runtime?
-> Are you able to run preview the data for single object or run it successfully with single object in source?
-> If there are issues or error at runtime please share the session log.
Thank you for your reply
I just tried to create a new mapping and preview data, not actually build it so dont know how it seen at runtime. I will try and lets you know.
for single object, I think there is a limitation of hana db version that informatica support, because i got the error that answered here:
that is why I tried to use custom query instead.