DSXchange

Hello I have a requirement like i have a huge file with 10 million records and i need to load the data to oracle table. We are using Parallel Edition on unix AIX box. Which option would be the best.I also have a requirement where if the job aborts in the middle of loading i need to rollback on what ...

thanks ray.that solved my problem.

My source value is like this : 2007-12-14 00:00:00 (timestamp datatype ) My desired output is : 14/12/2007 (DD/MM/YYYY)format as Date datatype Here i am extracting the data from Oracle database and loading into oracle database. I have tried several ways using To_Char and To_Date functions but in vai...

Thanks Ray that solved my problem

hi i have a requirement where i am extracting the data from fixedwidth flat file and loading the data to the database after doing some transformations. the file contains some '*' values. so while loading the data to the database i need to make sure that whenever there is * in the text field i need t...

thanks,

i got the answer i just triekd with -1 at the end.

thanks

Hi I am using currentdate-1 as parameter in the file i am producing. I am using DIGITS(DateCurrentDateTime(TimeDate())) [1,8] function to get the current date but i am wondering by using the same function is there a way i can get the yesterday's date which i want to use as a parameter in the file i ...

problem has been resolved.its just its not reading the path properly.

Thanks

should be a defualt conversion. try giving integer on the target side. but i am not sure.

hi Chulet,

Thankyou for your repy. I have seen it.
indeed there is a file but unable to read.

hi i have a problem reading the fixed width seq file produced. The seq fixed width file was produced in the previous job and i can view the data but when i was trying to read the data from that file in other job Its showing the following error. ##I TFCN 000001 14:30:49(000) <main_program> Ascential ...

hi i have a job from dataset to seq file.i need to produce the file as filename.#YYYYMMDDHHMISS#.dat. i have defined one job parameter which defualts to YYYYMMDDHHMISS. i am running this job in the sequencer and i need to pass a function which gives the aboveformat to the job parameter i have define...

Hello Ray,

i did specify QT=QT in the specification. Do i need to specify KEEP QT in the specification.

thanks

hi, i have a job from Oracle enterprsir stage to Dataset.the column QT from oracle has decimal dayatype. i am not changing the datatype of this column. In modify stage and in specification i just mentioned QT=QT and i want the output from modify to be QT with decimal datatype. the job is running suc...

Hi, I am extracting the data from oracle where a column QT is defined as integer.i am transferring the data from oracle stage to dataset.I am using modify stage in between. the column QT is nullable and i need to handle null values with blankspace.i tried using QT=handle_null(QT, " ") job ...