DSXchange

Well, that's an interesting bug and not one I'd heard of before.

Then we're not talking about one problem here and we're back to the odd comment you made in your initial post: In my case nothing comes out of the tranformer though the job executes If "nothing comes out of the transformer" not sure how you can expect anything to go into the target. And wi...

Not for Oracle.

chulett wrote:Obviously incomplete syntax, but enough to give you the idea.

You then fleshed it out, properly. Did it work for you or not?

Leave the "Surr ID" column out of the target stage entirely. Take the generated SQL and customize it to include SEQNAME.NEXTVAL as the value to insert into the surrogate column. For example, from: INSERT INTO COL1, COL2, COL3 VALUES(:1, :2, :3) To: INSERT INTO SURR_ID, COL1, COL2, COL3 VAL...

In other words, dump the "meta SQL" and do it all "in job".

Re-read what has been posted. There are no null values in your file.

I'm afraid you're going to need to give us some detailed description for our doubt first. Can you be a wee bit more specific about what you mean by needing to "get data from website"? I could guess what you mean by that but prefer not to.

Of course, which is why I made the word plural, in lower-case and in quotes. Jeez, calm yerself. At no point did I say they were the same thing.

You create a reference hashed file with a key for your 'group' column and a data column that is just an indicator - yes/no, true/false, whatever - to show if that group includes the target values. Do a lookup for each record and then write the result back to the same uncached hashed so it stays in s...

What kind of help are you looking for? Your Sequence is apparently coded to call this routine under certain circumstances and which fails / aborts the run. Apparently you had an "Issue in Teradata Load" and need to check the logs for whatever jobs your sequence runs. BTW, those error codes...

Not sure it's possible with just just stage variables as you'll basically need to check the data twice - once to see if you find those values in a group and then a second time to pass the group only if the first check didn't find anything. I've done this with a hashed file and a Server job, that is ...

Meaning... if Col3 has either 'ST' or 'PB' in it for any record in any particular 'Group', that entire group should be filtered out?

Unless we are talking fixed-width files here, "nulls" in a delimited file would actually be empty strings.

Usage Analysis *is* there... unless, perhaps, you have a very early 7.x version. If you have some flavor of 7.5.x, it is definitely there.