DSXchange

You dont need to configure anything. Just deal with the sql. -Load the meta data of both the tables -In the derivations, prefix it with the table alias name that you are going to use. Say A for Table A and B for Table B -When you go to sql tab, the generated sql will show select A.last_name, A.first...

Maybe we are jumping ahead here. From the columns that you are specifying, are you sending an NULLS to NotNull column? Maybe its complaining on that. Check the metadata in your dataset and your target teradata stage?

Now see it should work even then. If the columns dont exist in the metadata, they will not be created in the orch table and hence not passed to the actual table.
I dont know why its not working. WHat happens when you do an INSERT from your favourite sql tool ? Do the default values get generated?

You can also do it in a single job by writing a routine that taken in all your columns, does the comparison and sends out email using DSSendMail() sub function.

Hmm, dont send those columns in at all. I mean, remove them from the columns tab. This way they will not be present in the work table and hence no value will be sent to your actual table which will in turn populate the default values.

Need more details. DO you need a round figure or do you need accurate age. If latter, what precision are you looking for?

Yea, I was overthinking them. For some reason I thought 7.5.2 was the same as 7.5.1A. Nevermind. Me need coffee

In other words, x = the precision on your timestamp, aka, fractional seconds.

Define "call a environment variable(User Defined) in a routine" ???
IF you mean get its value then yes you can. This has been covered a few times in the recent past. Search for more details.

An exact search on "Heap allocation failed" pulled more than 15 posts. Try them out first.

Well, in your case the default values need to be set in your work table while creating the table, since the value is being populated into the work table from your actual table. Why are you using a work table in between. From what I am seeing, you are creating a work table, loading your dataset into ...

chulett wrote:No, there was a '7.5' first before any of the 'dot' releases.

I know that but talking about 7.5.2, there is an unofficial name and then the official name. Was it version 7.5.2? I cant seem to recall. Was it .2 that was to be called .1A

chulett wrote:(I'm trying really hard not to just say ".2" but it's obviously not quite working)

O yea, what was its official name, was it 7.5.1A

Somthing like

A simple seach would have revealed all. Try this postfor a start.