DSXchange

chulett

Yes, of course - I wouldn't have suggested it otherwise. Don't confuse that function with a Job Activity stage.

chulett

vmcburney wrote:There is a data masking for DataStage solution which is due in late 2009! IBM Professional Services have already built one using routines but they are not sharing it unless you engage them directly.

chulett

Search the forums for examples of using the UtilityRunJob function.

chulett

Hopefully Ernie will see the signal.

chulett

Ok... I meant what flavor of UNIX - HP-UX, AIX, etc. You'd really need to ask IBM to get an official answer to your question.

chulett

Does the transform stage stop testing all constrains after one has been met?
No.

Does the transform stage test constrains from top to bottom in the order that they appear?
They are tested in Link Execution order and the derivations are processed if the contraint equates to TRUE.

chulett

You need to have created them in the project via the Administrator first, did you do so? If you did, you'd need to expand a teeny bit on the problem you are having. Saying "not able to materialize" doesn't really give us much to go on.

chulett

For a small number, I'd just build separate jobs. Or, a preprocessor that puts them in a 'common' format and then a single load job. How many 'parties' are we talking about here?

chulett

dsjob with the -ljobs option, I would imagine.

chulett

http://www.dsxchange.com/viewtopic.php?t=119638

Not much meat there, however. What operating system? Are you using the 10g client to connect or do you get the bus error with the 11g client?

chulett

Google "DataMirror LiveAudit".

chulett

That information is only stored in 'at' so yes, you'll need to redirect and interrogate the 'at' schedule.

chulett

I'm not really aware of any 'limitation' per se, what kind of concerns are you having? Have you gone through the XML PACK documentation in your Docs directory? Have you gone through the XML Best Practices document that Kim Duke is hosting for us on his website? That would be where you should start.

chulett

Help yourself first. Search the forums for your error.

chulett

srinivas.g wrote:My problem scenario is...i will get a flat file with data and needs to be loaded in database, but the content of the file may vary each time.

Vary how? There may be things you can do but we'd need to understand the nature of the 'variation'. Can you post any examples?

DSXchange

Search found 42189 matches

Re: How do Transform Stage constraints work?

Re: How to generate Meta data at runtime in Server editon