DSXchange

hi when Iam running the iam getting these warning --> (Lkpparty is Lookup file) 1)LkpPartyId: When checking operator: Operator of type "APT_LUTCreateOp": will partition despite the preserve-partitioning flag on the data set on input port 1. Fatal Error --> XfmDerivedFeild,0: Unable to run ...

Iam readign CSV file using squential stage , input data from that it coming like 1-Apr-95 , 1-sep-00 how to Load that into Oracle DB I have tried stringtodate(input,"%dd-%mmm-%yy") But it is working only for data like 27-sep-95 not for 1-Apr-07 , how to overcome this Issue. Thanks Hasan

Thanks
That will work out in Basic transformer
How to do the same in usiing Parallel Transformer.

Thanks For info ...
My requiremnt is i need last date of the month from the given input date ..not the previous date... -1 will only give me previous Date

Can anybody tell me How to Get the Last date of the month....
Ex : input 1 feb 1993
I need output As 28 feb 1993 How to achive this.

How we can do that :--(

Hi
can anybody tell me how to resolve this warning Iam getting many number of times

Unable to open ODBC trace file
DataStage Job 2246 Phantom 7457
DataStage Phantom Finished

Hi ,

I want to read only 1000 records form 3000 records FROM a Flat File using sequential file stage. how to sovle this situation

"InsStgCcAccounts" is this your oracle stage? --Yes this my oracale stage... After the fatal error is there any log entry which states the log file is written to a path along with the file name? ---- No such entry shown that was just one liner fatal error What method are you using to load ...

Hi , I have input file from where Iam readign the data thorugh Sequential stage and have a transformation in between and doind transformationl like StringtoTimestamp Target is a Oracle Data base.... when i run the job i get the fatal error sent before. SequentialfileStage ---> XFM----->OracleDB

Hi
Can you please give wat could be the reason for these Fatal Error

InsStgCcAccounts,1: write() failed: Bad file number
InsStgCcAccounts,1: Operator signalled one or more errors.
Export Failed

try using DFloatToStringNoExp

Hi ...

Can anybody tell me what should i pass for one of the argument
(%scale%) in DFloatToStringNoExp function .

Now how to put this value in Oracle db in VArchar format ..pleae suggest

Ray,

Without any conversion function im just dumping into a text file and Iam getting data something like this :-- 5.1219e+12
Above value is same as input data getting from source database...
please put your thoughts on this....