DSXchange

balu124 wrote:and one more thing is cleanup resources option in the job tab of director is in desabled mode . Is there any extra settings required

Yes, that must be enabled in the Administrator for each project.

Did you read the XMLPACK_20_Designer.pdf documentation on the Trigger Column option?

You need to read up on the use of the Trigger Column option in the XML Output stage. When used, every time it changes a new file is created, so you could arrange for the value there to be incremented by 1 every 50 records to accomplish this.

You don't need any 'third party tool'. Can you not already dual boot your pc?

Or, if not, a simple call to your O/S to 'echo' it and capture the results can be used.

The 'repetition element' is generally the lowest level element, not the highest. And the Trigger Column controls when a new file is created, triggered whenever the value of that column changes.

Basically, yes - streams with identical metadata can be collected before going to a Sequential File stage. Partitioner not required.

I haven't had that experience, but then it's been some time since I've had to worry about loading Oracle tables with bitmap indexes. We found that the jobs ran just fine, but more often than not the indexes would be corrupt post-load. We ended up doing the traditional 'drop all and rebuild post-load...

I'm going to have to defer to Ray on this one, never having had the pleasure of dealing with character sets that actually required NLS be installed. From one of his earlier replies, and the issues you've been seeing, that seems to be a necessary step here.

Link Collector.

4. In simple Server Edition is Code oriented sort of job where as Parallel edition is user friendly. I'm sorry, but this one just made me laugh. As Ray notes, complete 'tosh'... something I needed to look up to get the full 'Chiefly British' nuance of. This was exactly the kind of 'list' I was hopi...

This is one of many 'SQL Meta Tags' that are available for use exclusively in the DRS stage and which are documented in the pdf guide for the stage. Is that where you are attempting to use it? SQL Meta Tags are unique functions that enhance or modify platform-specific SQL statements. When used in SQ...

If you have Server, then you also have the two Parallel Job Developer's Guides in pdf form on your PC. Start there.

Can you try it again after overriding the NLS_LANG setting in the job to match your database as I outlined earlier?

Raftsman wrote:I have a suspicion that I am hitting a maximum thread problem. Is there a way to determine this.

Work with your DBA, have them trace your sessions. They should be able to pretty easily determine if you are blowing out any connection limits.