DSXchange

hi,

It is clearly a lack of ressources.

Scratch disk,ressource disk or sawp may be the cause of the problem.

Monitor your machine.

the problem is that Mon is not a valid format for PX. ICONV and OCONV cannot be used in PX (unless using the basic tranformer or a server shared contanier) , since it is BASIC. why don't you create a PX routine like this : switch month : case jan => 01 case feb =>02 Then you have the good format, yo...

no way to set the data type of your colmumn into "date"?

it will be easier!

hi,

some date functions exist in the transformer or the modify.

Read the manual.

I'd like to add that date functions are not very powerful in Datastage. Try to use the database instead.

hi,

For extracting :you can filter in the database. If there is indexes on the columns, do not hesitate!

read method is about the query, not the lookup. The option is lookup type (Sparse vs normal)

spare means that lookup is made row by row. Normal => table into memory

Hi, for Anrewm 's problem

maybe your log is too big!

Did sou set up the clear log options in the administrator?

See also the space in your &PH& directory in your project.

Hi,

Decimal(15) to BigInt is automatic.

it may be useful.

hi,

Stringtodecimal(datetostring(#yourdate#,'%yyyy%mm%dd')

Go to the command line interface of the administrator and type the command :

DS.REINDEX ALL

hi,

aggregator is only for numeric types.

2 solutions=>

1. transform your date into a numeric value (YYYYMMDD) and use the aggregator

2. sort your data by date in descending order, then use a remove duplicates to get the max of your date

is it a SMP system?

if yes, setting the reference link partitionning to entire does not duplicate values, but set it in shared memory.

If your data is not too big, (be aware that the number of rows is important, but also the length of the records), it can work well!

What is the decimal separator specified for the project?is it . or , or none?

what are the options of the load?

Is it unrecoverable?

If u're using a SMP, Entire means that u use shared memory to use the lookup.

It is not so bad.

hi, this is ODBC, no SQL Server stage.

But as it is DS 8.0, you have the Generic Database stage (i've never worked with 80, i've only seen demos)

I'm not sure.

You also may need a license to get the stage on the palette.