DSXchange

this column is not commin from the source

I have to populate the crreationtimestamp column
like "2007-03-20T09:21:22"

for this column sql type is timestamp

Thanks,

Do we have any function for generating the sequence number in Oracle
in PX.

Thanks,

DSguru2B wrote:Its complaining that you have defined it as ustring? What is the datatype, set it as timestamp or Date with length 38. The sql select will automatically stick in a TO_CHAR() to it.

Its working ,
Thanks for all ur help.

what happens when you run that sql from anysql tool, does it work? Check the format of that field it is possible that you might be missing the microseconds part .......... yes, Its working fine in Toad and server job too. I donot know when I am trying to develop the same Job in PX as they preferred...

us1aslam1us wrote:Extract that field as string(char/varchar) then do an explicit conversion to the timestamp using stringtotimestamp function. While doing the conversion check for the timestamp format.

I am trying to view the select query form the Source DB.

Thanks,

HI, I am extracting data from Orcale and it was showing some error for one column Error executing View Data command: ##E TFIP 000000 14:56:37(003) <Oracle> Error when checking operator: When binding output interface field "CREATION_DATE" to field "CREATION_DATE": No default type ...

sample file: <EnterpriseDocument InterfaceName="XXXXXXXX" Version="1.0" CreationTimestamp="2007-03-19 18:16:51" CreationSource="Enterprise"> --<Fuel BUC="001418" Date="01/12/2007" BILL="096146" BOLDate="2007-06-01" INVNO...

For the Inital run choose the option Inserts and load the data from FF. After that make a self lookup with the Target table and compare the columns from source and lookup colums . On the target side there will be two output links ,one for insert and another for updates. In update check the key colum...

I tried to change in options to reject and fatal but still its reading the file and job is not aborting.

Thanks,

can anyone help how to capture the Inputfile in the Joblog table after the whole process is done.

Thanks,

What does that mean? What 'that' do you need a routine for? :? No , I dididnot mean that I have created a Joblog table and thats diff DsJob and calling the Job in sequence and trigger the Job after the process Columns: jobname, status ,inputfile ,outputfile and other colmns I would like to capture t...

The file name can be passed into the job as a parameter - after all, it's going to read that file. Therefore, the filename column is derived as the value of this job parameter. The file name paramet ... I donot have the premium account. I have created a paramter filename and DSJob (wht should i pas...

[quote="chulett"]Ok, good... just wanted to make sure you weren't expecting anything more from me. Yet. :wink:[ I have already a script for extracting the files to Ds server and looping it Still i need to write another routine for that I would like to know one more thing.After the above pr...

In the name space it will just import the Xpath.

I have imported the schema and try to validate the XML Inputfile if any attributes are missing then the job should abort.

In my case its not aborting , its reading the header file without loading anything into the target stage.

Thanks,

How to validate the xml file with the XSD file when the file is with just header information without detail .

I checked with XML schema validation from the XML input stagep still its not throwing any error.

can anyone help me out.....................

Thanks,