One Star

Show user define column in tMAP before saving data.

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.

Abhishek Dabas 

  • Data Integration
3 REPLIES
Nine Stars

Re: Show user define column in tMAP before saving data.

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

-----------
One Star

Re: Show user define column in tMAP before saving data.

Hi Vapukov,

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.

 

Regards

Abhishek

Nine Stars

Re: Show user define column in tMAP before saving data.

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 

-----------