DSXchange

Thats the windows (carriage return) new line character that you see.
You dont have to open the text file in Excel to convert it into csv.
If your delimiter is already Comma, you can directly save the file with ".csv" as extension.
Else change the delimter and save it.

Should you just need to configure your client?
Did you try customizing?

Wouldn't you need to recompile the job when you rename using the dsx file edit opiton?

I got this idea, when I saw that, you are passing blank values '' to the Decimal feild.

That is the folder to capture the 'COMmand Output' as file format.

I supppose by not passing the invocation id, you are trying to keep on triggerin the master job. When you run the Job sequence from Windows, you will have small box with a display of Invocation id, when you see the pop up with prompts for Parameters. Similarly, individual JobActivity will also be en...

Looks like you are converting from Varchar to Decimal.
Do a PEEK from the first transformer to see the values thats been passing to the next.
BTW, why do you need to two transformer for this purpose.

Is there any compilaiton process going on in your server in parallel by any chance?
Does your Transformer do any complex operation or calling a routine?

Both even and Odd in same output?
Looks like you need continues Sequence number.
If you want it seperately. Make the data to run in two node.
Make the Partition as Entire.
Run a SequenceGenerator.
One node will give you odd number and other will give you Even number.
For the same set of data.

But what happend to the space inbetween the Number and Name?
Is that a special character avaialble in the Database itself?

Hi I am getting some more new message from Phantom File name "OSHTRACE_jb_aa_aaaa_aa_aaa_load_FILE_to_aa_ref_aaa_aaa_aaaa_aaaa" too long. Truncated to "OSHTRACE_jb_ee_aaaa_aa_aaa_aaaa_aaaa_to_". Thanks Man Is this a name of any of your component? jb_aa_aaaa_aa_aaa_load_FILE_to_a...

Correct me if i am wrong. The DS Developer manual has this example which shows the precision will not be lost after abs function. This example uses the Abs function to compute the absolute value of a number. AbsValue = Abs(12.34) ;* returns 12.34 AbsValue = Abs(-12.34) ;* returns 12.34 Thats right....

I just removed the mask, just check if that helps.
Inorder to avail the full feature, you just have to enroll into Premium memership!!

The trick is, you ll have to find the list of statements that has to be executed in ETL box and the ones that has be executed in DB box for better performance. Ah, that sounds like the "balanced optimization" feature coming in the next version! That sounds interesting!! Is that in 8.5? Do...

You can give two single qoutes. As ''.