DSXchange

On how many columns are you sorting the data in Sort specifications. This does matter.


Did you change any default settings in Sort stage like: "Maximum number of rows in Virtual Memory" ?

Sonia,

What else are you doing in this job and how many number of rows are being processed by this stage for 1-2 minutes of time you mentioned ?

That means we have take their classes. But people who have enough experience and did successfully deploy some projects before with no formal training from Ascential. I learned it by moving from one group to another one which is doing DW and that was first project and transition in DW and DS. Well le...

I am sorry Guys. I know this is really not a technical question and I did search before posting this topic.

Can any one tell me whether their are any certifications for DataStage or any other Ascential Products either from Ascential or from other companies ?


Thanks for ur time

How can I use DB stage to calculate number of records coming from specific join condition. This stage has some metadata, but is it possible for me to just write as Select Count..fromTable A..with some where condition.

Any suggestions ?

Can anyone forward me any links or information on CRC32 Routine ?[/quote]

continuation to what amsh76 has asked.

How to read them a hierarchical flat file in DS ?

Where are u having this error ? I mean in which stage?

How can I determine what the next value assigned will be? It will start from 1 and go on. How can I reset values? use the following in your before-job subroutine UPDATE SDKSequences USING DICT VOC SET F1 = '1' WHERE @ID = 'yournumber'; Where is the sequence stored? Stored in DS Universe Hash file A...

This is a very wide open question. So many issues have been posted on this forum. You can do a search on that. In short give the assumption that you have Oracle and DS on different machines across the network, take it that Hash-file look ups are much faster and they are re-usable in different jobs. ...

Oh yeah . the reject link. but do u want to write the rejected data into SQL files or Sequential files. I was confused ?

Post the complete error message to make sure that you are having problems with Link Collector.

What other stages are you using in this job?

I don't think you can use DSSETPARAM within the job. I think they are one of the first things that are executed when the job is started.

Look on of Ray's postings where he mentioned the Order of execution of variables in the job.

Holgi one way to make it more 'visible' is to rename the link to something more meaning to give an idea of what the trigger is meant for?

Just a thought !

This is the best one for me :) You can also skip the Sequencer stage in this case and use a Custom trigger, which can handle multiple conditions. For example, to check for Ok or Warnings in one link, put this in the Trigger: StageName.$JobStatus = 1 Or StageName.$JobStatus = 2 Mix and match as you n...