DSXchange

Where you see the loosing information?
If it is in output, it should atlest show you .000000.
Use Peak stage to get the values showed in Director.

May I know what is the values for APT_DECIMAL_INTERM_SCALE and
APT_DECIMAL_INTERM_PRECISION?
Have you changed it, if so what is the new value?
Have you tried to set APT_DECIMAL_INTERM_ROUND_MODE to "Discard any unrepresentable fractional digits"

Hi Murali,
There is a section called "Setting Up Properties for the XML Input Stage" in XMLPACK pdf. You might get more info reg this.

If you lookup data is too huge, you can opt for sparse lookup. Where you have have your query in the in the database stage (if the lookup table is DB2)

Ray have given you the solution.

cat file2 >> file1

Or
Cat file1 file2 > <NewFileName>
Or
Read the two file in the sequential file stage and write to a single sequential file stage with Append option enabled.

...[1,len(SF1)]:..

This wouldn't require if you mark all the column as Varchar.

The point is '' is not Null. You made the date column as Nullable but not ''ble . So you will be only null in date field in this scenario.

Can there be an option to track the user history. If the user entered in the wrong forum, keep a track of it. If he does the same mistake again minus 10 points or something like that Most new posters will have negative points in their score board. Very few have access to post directly in FAQ forum....

Concatenation or Join?

4th point given by Kenneth should be noted.
Adding up of consicutive active stages wouldnt affect the performace much in Server job, the same wont work in PX. People might happily add more stages which will directly affect the performace, even the combinalble are enabled.

If jobs are made to run in parallel, find the accumulated max usage for memory for the given data. Add some buffer to it.
Calculate the value for the production, with the production data using this factor.

alphac wrote:if you set a = b, engine will truncate b to varchar(2) first and then compare with a.

if you set b = a, engine will not perform type conversion.

.....

This is a nice study over filter stage on your first post alphac. :D

Check out the Display option, it might have hidden the rest of the field's information.

But you can try with the frist 2 character of the Varcahr(6) field to compare with.

Why only in unix and not in datastage?