DSXchange

I don't believe so, no. And when I said "7.x advice" I really meant "pre-8.x advice".

Do you have any kind of a playground/sandbox project you could run some trials in?

Again, that's 7.x advice, not to mention the fact that it would affect everything in the repository. So, what was the specific advice - run that, export and then set it all back?

Setting a 'flag' to Y/N is no different from setting it to 1/0 and it's all extra work. Just use the expression in the derivation and the Boolean output will automatically be set. For example: svIsValidEffDt -> IsValid("Date",EFF_DT) Then a simple "If svIsValidEffDt Then X else Y"...

Server is quite tolerant of diversity and doesn't run the police state that PX does so will quite happily put "OH NOES!" in a Char(2) or even a Decimal. The metadata wouldn't be enforced until it hits the target and then not always, depending on the target itself. So the onus falls on you ...

Hard to say, not having a clue where LastRunDate comes from (what 'job itself'?) or what exactly you mean by 'pass in command/ODBC stage'. We need more details about what you are doing... or trying to do.

You should check validity before transforming the string to a date. And your reject constraint is wrong - what's in the "OR" is invalid and you seem to need more parens to get the AND/OR priority correct.

Sure, feasible, seeing as how that's pretty much exactly what I posted.

The columns which i am going to include are not indexed in the table. So i thought it would be better to add the conditions in a transformer and filter the data. Filtering isn't necessarily helped by indexes and depending on how much of the data would be filtered out, doing it in the job could be t...

Right, you need something, some other process to get / set parameters and run the jobs. That could be (from easiest to hardest) a Sequence job, a script or a hand-coded 'job control' job or batch.

There *is* a row out of sequence or it wouldn't blow like that, you need to find it. Don't forget that when you string sort, "12" comes before "2". (etc)

You need to execute a 'bind' step, something that searching for 'bind2' should turn up for you.

Ah... yes. One must first have established breakpoints before there will be anything populated in the 'Edit Breakpoints' dialogue.

I would think it should work if both fields have two spaces in them, and I'm assuming that's what you mean by "blanks", yes?

That made me L-O-L.

Maybe it's changed for 8, in earlier versions when you go to the Manager and do Export / DataStage Components there's a Options tab you can switch to and 'Include in export': Defaulted Properties Read-only objects Referenced Shared Containers The second one is the one I was referring to that needs t...