DSXchange

Mat If IsNull(<Date Field>) Then If Condition X Then #DefaultDate# Else SetNull() Else <Date Field> In your statement the first IsNull will not have any problem. But in your "Condition X" if you still use the <Date Field> without having null handling then the records will be dropped. Make ...

I agree with Kim doing it in Manager is easier. Also you can do that using designer....Or another way is to right click the job in designer and select the properties. Inside that you can go to Category tab and type your new category.....

Reddy

Do a search on "Access violation" it was covered before in this forum

This functionality is well handled in Datastage by using hash file and having the pre-load memory option enabled

You need to pass in the unique name for which it gets the next surrogate key. The value is stored in hash file and you can always reset the value by updating the hash file

Hi

Do a search on this forum with the keyword project currently locked this topic was covered before


[/url]

Is there any specific reason you need to use Merge stage. If it is just one value you can store it in a hash file and do a lookup. Or you can write your date value to a sequential file and before running this job read the sequential file and pass the value as parameter

Hi After creating message handler you can use it for individual jobs. Go to the job properties and choose a message handler to be included in your job. The list will show you all the message handlers currently defined in your project. The message handler gets compiled with the job and becomes part o...

Hi Double click you sequential file stage and click the output button and then Columns tab. Inside that right click and select properties inside that you will find Extended column in Position 4

Having database table as lookup is another option which you can consider. I never tried with 30 Million records. I hope someone would have done this and can comment

Hi

This error occurs when you mistyped the formats especially in your datetime. Post your SQL it will give us more info.

Thanks for mentioning that Craig. I did skipped all previous thread.

Calling a function for each of your column and every row will slow down your entire process. Now days tools are available and improved alot.

Hi trokosz

This is a server question and not related to Parallel Jobs. In server job you can have reference links can be a table or a hash file. Thats what manoj is asking which one is more efficient

Go to Routines Folder in the Designer. By default you won't see the routine folder. You need to enable this by clicking Tools/options and inside that go to appearance/Repository Tree. Click Show routines. A good start is to look at the existing routine codes. Double any routine and inside that click...