DSXchange

My fault.... the metadata came in as VARCHAR, but the underlying table is defined as CHAR which explains the trailing spaces.

Sorry for submitting a question without doing the research first!

Hi, It seems as if the Transformer stage is adding trailing spaces on my VARCHAR columns. I'm taking a flat file with columns defined as VARCHAR with no trailing spaces, and when inserted into the ODBC stage, also with VARCHAR, the columns have trailing spaces. I've used trimB and trim in the transf...

We are just starting out with datastage. I'd like to get a recommendation on what is the best way to configure the server installation to support our multiple environments (dev, test, prod). We plan on creating 4 projects: DEV, TEST, PROD, VERSION. Some questions: - Is it recommended to split these ...