DSXchange

Or you can use explicit null handling with using modify stage as explained in the video Tech Tip.

trobinson wrote:To be precise, it is not 75% of 79 or you can miss 19 out of 79. The questions are weighted by category, I believe.

So it is 75.949367088607594936708860759494%

Ray,Ken - Is there any strong reason why, to keep seperate job for each table? Otherthan better understandability and maintanance.

Bit tricky, I need to work out and check to answer. But I guess should be the partiton on the two key. BTW may I know what is the type of join you perform?

Exception handler will get the control only when the job gets aborted. There wont be any use of UtilityAbortToLog () then.
If you need to abort within in the same job, you have another ugly approach to marking 'bortAfter n rows' in transformer.

This is wonderful step taken to make use of updated technologies. Great work!! Keeping in mind the load to the pc, I could see clarity was compromised. As mentioned by all, due to the varied size of the video, the letters looks blured.

Hash partition on Zip and Age. Mark the both as key in sort stage. Mark AllowDuplicates = False. Reverse the order of sort for your desired result. You can accomplish within single stage.

loveojha2 wrote:Other options could be Len(col2)=0
or Col2=""
or isNull(Col2)
or Col2=@NULL.STR

Checked all the possible condition
But needless to check for empty string on a Float column.

It is worth to try REINDEXing once you get full access.

Work on the other way, Check for null and give an empty character '' instead.

With the given FI-Then-Else condition you can directly replace the target table with the whole set of input table.

uvconvig file under the DSHOME will have the entry of the max number of Type 30 file which can be used at time.
Stop the datastage server, regen the uvconfig file, and restart the server.

Not much clear with your requirement.
What is that you expect to change in
on DETP derivation.

It's secure ftp, folks. You cannot supply passwords to it like this, period. You need an RSA Key on the target system to allow 'passwordless' access. Or fall back on 'regular' ftp, if allowed. If s ftp works from command prompt, shouldnt it work the same from batch file from windows? Joseph - Hope ...

Hi Xpert, Do a search. This has been handled and explained several times. The available options dsjobs has a option to pass paramter by -param . All your parameters can be declared in a sequential file, and during runtime the file can be read and the values can be passed without human intervention. ...