DSXchange

I can not see the entire code ............I tried to take premium membership couple of times but during the process screen just disappears.........


can u please send full answer...........

I have to read this file , every record starts with 'UNCERTIFIED - 5 YEAR' then I have 8 lines following that header , I m planning to create staging table to store these 8 lines into 8 columns thus store first record , when i hit 'UNCERTIFIED - 5 YEAR' again that means its 2nd record ......8 lines ...

thanks for ur quick reply ,

as u said .........i could view this file with seq stage with just one column , i did not understand what to do next ...........pl sugest

Hi all, I am getting data in notepad ...I have file format which defines what every line means , data is as follows: 1 UNCERTIFIED - 5 YEAR - 12345 12345 123450 - NJ DEPT OF TRANSPORTATION xxxxxxxxxxxxxxxx xxxxx xx xxxxx - 122456 07 16 2008 x 0 DRIVER NOT FOUND 1 UNCERTIFIED - 5 YEAR - 12345 12345 1...

no I tried in oracle , it works .............

I am writing procedure to take care of this ,
but for more info :

date -(4/24) also works ...where 4 is the interval subtracted from hours..........

Thanks.

Hi , we are getting time with 5 hrs added (zulu time) from EST time . I have to convert data to subtract 5 (or 4) from the source time to match to local time depending on daylight saving . in short I prepopulated time table with all dates with flag for daylight saving . I have query which works fine...

how can I say not to connect it to that scema , i do not want to connect to that scema ............

why only few files got rejected ...........if i run that single file it loads .........

Hi all, these are the errors I was getting : .............. XmlLoad_mul_5_unix..XML_Input_22: XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 0, column: 0): An exception occurred! Type:NetAccessorException, Message:Could not connect to the socket for URL '...

Hi I am processing xml file , job design is : folder stage .......>input xml stage---------> seq file stage . out of few thousand only 4 to 5 are getting rejected with the error that could not validate to main schema , I have unchecked the validate xml oprtion , but not sure why it is still validati...

thanks Ernie, I will look into it , I have to look into multi instances of the same job. if I create all(40) sequencial files at one place and then create many instances of the same job, running all instances at the same time and appending into those files , will it do .? I will take care of source ...

Hi Ernie, U understood right , but let me explain , I have suppose 100 xml files in sub directory(for each patient i have separate xml file) , each file has multiple instances of data(loading into cross walks) , for ex names of the crew member attended on patient .In this case I made crew member id ...

Hi ernie, thanks a lot for reply, I am dropping all columns and processing only columns which are required in particular file. I mean , folder stage ---> input xml stage --------> 40 seq files stages attached to one input xml stage , at the output of xml input stage i m processing only required colu...

Hi all, I have job , folder stage ------> input xml stage ---------> seq file stage . I have one xml file for every patient report , job is working file , I am creating many seq file depending on the key from above job to populate cross walk tables , but it is very very slow , its taking 4 hrs 15 mi...

Hi All,

Thanks for the replay ,

My manager doesn't want to use quality stage (dont know why) ,
I have to write unix script which will take care of all cleasing ,

I wanted to do it in datastage but it seems it is very difficult to do it in datatstage.


thanks for all ur input