DSXchange

What? What in the heck makes you think I "don't like" your post?

Just trying to understand what part you need help with...

How much help do you need? The documentation on the substring operators is clear... for the "to the end" part, either hard-code the maximum size of the column as the size to use or just use a sufficiently high number as it doesn't matter if it runs off the end. If you really want to, you c...

That sounds more like a 'workaround' to me and doesn't really address the root of the problem, especially if you didn't have that on before. But... ok.

Not exactly in the 'simple' camp but perhaps a good starting point: viewtopic.php?t=85578

Sure looks like it has been activated, are you still having issues?

That kind of thing always screams 'resource issue' to me. Have you talked to your SysAdmin and/or DBA about it? Perhaps some settings need to be bumped up.

I'd be curious to know - rounded to what?

An exact search here for "computed blink" will help.

Do you understand why your Trim examples didn't work?

jerome_rajan wrote:Oops! Just realized I posted this in the wrong forum . Can the admin please move it to the right forum?

You betcha.

Interesting, so it is checking the actual table's metadata rather than what is defined in the stage? From the docs, there is an option of either "Fully generated SQL query or Column-generated SQL query", if you are using the former then perhaps a switch to the other is appropriate. I don't...

Clarify for us what exactly "they're not defined at job" means. If they exist in the target stage, they will be included in the generated SQL. It doesn't work like Informatica, if you have that expectation.

You'll have the same issue with any kind of derived field, like a sum for example. Even if you are summing non-nullable fields, it will always consider the result to be nullable.

korca123 wrote:One example is the Customer ID field.

That's fine. I've never been anywhere where that would be considered PII but if you need to that's fine and it will certainly increase the challenge.