DSXchange

Sainath.Srinivasan wrote:Make them continous in a single line.

Thanks,

But the file i recieved from the client is in below format.

proc_date
20030302
20030406

I can't change the format, please suggest me which format or which settings needs to be done to read such text file

Could you please also add the fatal error message in your post I am getting the below fatal SeqLKPProcessing_date,0: Short read encountered on import. SeqLKPProcessing_date,0: Expected 8 record bytes, got 2 SeqLKPProcessing_date,0: Import error at record 2. SeqLKPProcessing_date,0: Operator's runLo...

Hi All, We a have text file with proc_date as the column and our requirement is to use the text file as the lookup with the incoming input records from the source database . For example The text file has only on column proc_date with the below values Proc_date ----------------------------] 20080306 ...

Our last webinar was on this very topic. Search the forum for checkpoints for many discussions on the topic. It is also detailed in the online help for Sequence (no 'r') jobs. ... Thanks, Can you please guide with this in more detail... I am not able to get required solutions... It will be really g...

hi All, I have below two requirements to do lookup please suggest me and correct me if i am using wrong stage for my requirement. 1. Requirement 1 is that all records coming from the database should match the sequential file processing_dt. If matches then only those records are taken in to ouput Ans...

Hi All, I have four jobs job1(server), job2(parallel), job3(parallel), job4(server). I have sequencer job which is designed to run all the four jobs. I have requirement if job4(laoding of data in table) fails then the sequencer should restart and run only job4. Please guide me how to work on this, a...

Hi All , I am using an after job subroutine for insertion of records into table using an unix script.. The below script is wrritten #! /usr/bin/ksh # Load into od_trans_map_output table for HALO Transaction Mapping isql -Uwindevdbo -Pwindevdbo12 -SIISS1 <<-EOI1 use odstest go truncate table od_trans...

Hi,

I need to format the decimal values coming from a source in this format
NNN.NNNNNNNN, i.e if the input is 6.56 the output should be
006.56000000,
I have tried using the fmt function but i'm not able to get the required output

Can someone help me with this

Please delete your duplicate post before anyone responds to it Thanks ray, Can you please guide me if my understanding is wrong. I thought i will store the output in the file and then do the look up with the same file again and then insert into the fnal table. So which ever matches i wont insert an...

Hi All, Can anyone please guide me how to restart the job incase if the job fails . for example i have 2million records to be loaded into the table. i have input a seqential file or the dataset needs to be loaded into sybase database. i want to just use insert commmand by deleting the perious record...

Hi All , I have requirement in which i need to insert or update the sybase database. Since it is daily job in which expected input records would be 2million records. i didn't have sybase stage in my pallete i have used ODBC stage with the write method is upsert Upsert mode is update or insert. From ...

Prove that the "external C routine" is efficient (not the bottleneck). How do you define "performance" in an ETL context? ... Thanks to all... Yes i am using an ODBC stage to Insert or update the records coming from the source datasets into sybase database in parallel job. Since...

hi All, i am facing some performace issue while loading the data into table at the output stage I am using below stages to load data Four Datasets are concatenated using funnel stage late it goes to the transformer stage which invokes a external C routine and loads into table Is there any bulk loadi...

hi All, My requirement is that we are extracting from the source whose data of feild process_date is type of datetime. I have converted process_date to char(8) for my lookup purpose. I have to load in Dataset file back to Timestamp datatype so i tried using StringToTimestamp in transformer stage fo...

hi All, My requirement is that we are extracting from the source whose data of feild process_date is type of datetime. I have converted process_date to char(8) for my lookup purpose. I have to load in Dataset file back to Timestamp datatype so i tried using StringToTimestamp in transformer stage for...