DSXchange

its in yyyymmdd : hr:mm:ss

I was initially using link.column [1,4] in the transformer for the derivation of the column but, its giving error that non numeric character present where numeric expected..

both source and target are SQL SERVER

Hi,

I have a job where, I am using a column say Px_A (source) which is in TIMESTAMP to use it for a column at target say ZX_B which is in integer and I need to get there only the YEAR from the source column PX_A.
Can anyone please guide me how I can achieve that.

Thanks

hi...well its simple job with one to one mapping with over 56k records...the source and target are both sql server...with only one source table and one target table

How can I increase the rows/sec while running the job... I have the transaction handling and array size both set to 500 each, but am getting only 10rows/sec..someone please suggest.

Thanks

Hi am running a DataStage job (server job)...the job ran successfully but at the end in the log files in director I have a warning message...which I dont get...can someone please reflect on it, and let me know how to get rid of it.. DataStage Job 4364 Phantom 6488 Program "JOB.1496282158.DT.157...

ray.wurlod wrote:Use a database stage (eg ODBC stage) to service the reference link, and use user-defined SQL that specifies the BETWEEN condition. You can generate the two dates using SQL functions. ...

but wont it be better performance wise if we do it in transformer itself..

chulett wrote:I know, it wasn't a question... I posted it because the answer you got was specific to PX jobs.

i did figure that out, so what would you suggest

chulett wrote:Server job.

yes server job

I need to calculate date, and the requirement is, if the date in column column_X is between the current date and the last 4 years then 'Y' else 'N'
can someone please help me with that, how I can do that in transformer.
Thanks in advance.

Call it what you like, I'm trying to assertain if you are updating 16 rows in the one update you posted on purpose (i.e. it was expected) or by accident and it was an unexpected result. The former you may have to take up with your DBA while the latter could be because (for example) your key choice ...

chulett wrote:Answer my question, please... are you intentionally updating multiple records in the target table with each record you process?

by multiple do u mean DUPLICATES...

OK, then I'll concur with Craig, because DataStage expects the database server (or ODBC driver) to be silent on request but yours is returning informational content. So DataStage alerts you to the fact that unexpected output has been received. alright, so what exactly am I to do, to get rid of thos...

ray.wurlod wrote:I don't see any value in that recordset that could be converted to smalldatetime. ...

actually that is for the load_date column for which in transformer am using the date.tag(@date) in derivation to get the current date..