I am working on a user case where customer wanted to view the user define field names with some metadata about those columns instead of actual database column while mapping data from source to target. Basically, its about how to add one level abstraction to real time DB columns.
Thanks in advance.
not very clean what You try to achieve, but if I understand correct:
it possible for Input components
define schema as You need (want)
- col1 INT - col2 VARCHAR(25)
than use this schema in tDBInput use query like:
SELECT realcol1 as col1, CONCAT(realcol2,'_', realcol2) as col2 FROM realtable
but for output components, You still must use real schemas
Thanks for the reply.
My problem is not in the input side. I Don't won't to show exact DB columns to end user on the output while mapping data in tMAP. Is it possible to show custom column to user in the tMAP and while running the job data will be saved to the exact columns.
Hope this will clear my use case a bit.
Think, You are looking in wrong direction
if You do not want to show real structure - look for ESB and SOAP or REST API services
in this case You provide API documentation and interface
other traditional way, use CRUD stored procedures - and call them after transformation, but this could kill performance
and the last - normally End User do not work with tMap, he just provide source data for Job and receive result, if it Your client - in 99,99% it could request open source code of any You hidden transformation