Title column to lowercase

One Star pnv
One Star

Title column to lowercase

Hi,
I extract firebird data to postgres.
The process is good with jobs design. But i must rename for each process column name in metedata schema of postgres (Uppercase to lowercase). I would like to automate the process with tmap.
With tmap, i know to do uppercase to lowercase values in field, but i would like change column name to uppercase to lowercase.
Can you help me
Thanks
Christophe
Employee

Re: Title column to lowercase

I'm afraid you can't automate this transformation because we are talking about metadata, not data.
Two Stars

Re: Title column to lowercase

If you only need to do this once, then export the schema as XML and load it into a text editor and do a search and replace. Then reload the XML into the schema. I do an export/import when I want to create schemas quickly.
If you need to do this "on the fly" then you would need to provide some more information, such as:
- do the tables already exist, or must they be created at the time of the job?
- can you do metadata queries against firebird?
I'm sure there's a solution - doing a metadata query and a data query, merging them together with a tMap to create SQL statements and then executing those statements against the postgres database. A lot of work, but I'm sure it's possible.
Cheers,
c0utta

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads