DSXchange

Sunshine


There was a post from Ray years back about how things run. It does says what happens when you start the job, which one takes priority etc. You need to do a search with keywords to dig out that post. Anyone knows the link?

Hi Rodre

Another way to think is to swap your Sequential file to reference and hash file as your main file. Treat your hash file as source and convert your input Sequential file to hash file. This is just another way to do

Somu Your Input is Char and Output is Char again. So you need to follow the steps 1. Convert Chat to Date using StringToDate Function 2. Use DateFromDaysSince Function to the result of Step 1 to Substract 1 day from the result. 3. Convert Back your date result to Chat type again using DateToString f...

Lalitha

First thing is to find out the volume(number of records) you are dealing with. For small volumes Server job are better than Parallel jobs because of the overhead Parallel job has.

Parallel jobs main strength is to run fast for large volume of records and it is scalable.

Somu

Try DateFromDaysSince Function. This functions adds an integer to the baseline date and returns date.

Regards

Somu

Refer Parallel Job Developer Guide under Function(Type Conversion Functions)

Thanks

Somu

You can use IsValid function to find out whether it is decimal or not.

Santosh

You can also use the Sequencer and Loop for your job. Inside your loop have the Wait for File and while running your job clear the file so that when next file comes it will be ready for next run.

Chowdary

What you can do is use a Aggregator Stage and use the Last function to update a record when the the last record is read. In your existing design in place of Link2 add the Aggregator stage which will solve your problem

Chowdary If I understood you correctly, it's datastage Architecture. You can never control the way it works. It's already designed in such a way that as soon as its required link is finished it will start processing its next step. Are you trying to control the stages inside your jobs to run when you...

Williams The refresh interval can be changed in the director. The maximum value it can hold is 600 seconds or you can turn it off and do it manually whenever you want to refresh the director. In earlier version when a project had too many folders and jobs had this problem in director. But in latest ...

Deepak

Which version of DRS you are using. In 7.5 it works without any error. I completly removed the table name and used user-defined-sql it works. I also used a stage variable as table name in user-defined-sql which too worked without any problem. I don't see any problem with using this stage.

Hi Vimali

This topic was discussed before. Look at the following link viewtopic.php?t=92733

Thanks

Mat

Are you using this out_diff_mc.DAT_FERM_MACR field in any other Stage Variables?...

Mat

Is it possible to post your full conditions