DSXchange

Hi,
AnOther interview question.

kris007 wrote:Here's what you would need to do

No, not really. Unconditional is just that, unconditional - none of the other links are needed. We're missing something here, something Vijay hasn't told us yet...

What leads you to believe it 'runs only the first occurance'? Some specific examples would be good...

I am not typing anything under Trigger tab, everything I am selecting from the Activity section by right clicking. Good, thanks. I only mentioned it because you have been doing it in all your previous posts when you posted your trigger code. Now... do you have any of the four 'Compilation Options' ...

Like most things DataStage, many different ways. How about sorting the incoming data and then using Stage Variables to check for a 'group change'? The first time you see whatever data makes each record unique, you send it off to the 'non duplicate' table and everything else for that group goes to th...

Ok... a simple answer that doesn't work when you add more details. You've got two answers in a normal Server job: 1) Treat it as an 'all or nothing' load with a zero transaction size. 2) Turn on Transaction Grouping. Neither would work for you, it seems. The first doesn't meet the requirement and th...

It's the technology that permits multiple versions of DataStage Engine to co-exist on one box. Not according to Google! It must be either the: International Trepanation Advocacy Group (oh my) or the Information Technology Association of Galway or the Iowa Talented and Gifted Association or the Info...

Just a small nit, Meena. Your code as written would 'mv' the file into the Project directory.

I think I've read that Parallel server has some functionality for determining data changes when no update_dt is available. Isn't that the Change Data Capture stage? From what I've heard, it uses CRC32 under the covers so more properly CDD rather than true CDC... and it's not like you couldn't do CD...

DataStage includes a CRC32 function, doesn't that count?

Well, actually... they are the 'KBA Job Control Utilities' and 'KBA' is Ken Bland and Associates. You'll see names like Stephen Wong, Michael Favero (and others I'm sure) in addition to Ken's. And yah, been relying on it heavily for 3+ years now. I've extended the 'wrapper' code around it quite a bi...

Um... what? Oh, never mind - amazing what a quick Google can turn up.

Or... create two Sequence jobs. Run both the first time, then only run the second after that. Of course, the first one doesn't really need to be a Sequence if all it does is run one job, but you get the idea.

Will you be upgrading the 5.2 server to 7.x or setting up a new 7.x server on a different machine? That will dictate the steps involved. For the former, it should be as simple as installing the 7.x software 'over the top of' the 5.2 installation. Upgrading will be automagic. For the latter, install ...

sattibabu_2004 wrote:I must rollback, if any of table 2 insert fails I have to rollback insert on table 1 also.

Why not just set both links to have a zero transaction size?