DSXchange

Hi, i am writing data to sequential file(tab delimited) in Server job. The view data in server 'sequentail file stage' is fine when i am using same data file in parallel job .when i want to view the data in parallel sequntial file stage it is giving follwing error ##I TUTL 000031 11:27:49(001) <main...

Hi all, i have to calculate change_ in_ TNA ( field) for new incoming records based on same records that alredy exist in sql server database. the key columns to calculate 'change_in_tna' are fund_name, fund_no fund_name, fund_no are not key columns in sql server database. but there exist more than o...

Hi sainath, Thanks for ur reply. i am trying to develop with Merge Stage, that is the reason i have posted 'job aborting in merging of two files' (recently in other post ), i don't have other key column in table other than those two fund_name, fund_no. is there any other way to solve this problem. Y...

Hi , Thanks for reply i did redesign of job (rebuliding merge stage) but same problem. i am designing like this merger- ----> transformer- - ----- -> sequentail file. i am not doing any transformatios in tarnformer ( just merging in the first stage). even after redesigning (reduilding merge stage) i...

Hi all, i need to update existing records based on new incoming records. i am taking existing records into hash file. matching key columns are fund_name , fund_number. Hi, i am uisng look up with fund_name , fund_number. when i take existing records into hash file , i get only one record (with fund_...

Hi , Thanks for reply. i am merging(pure inner join) two files. both files are in same format. the key columns both of them are fund_name, cik . there are no nulls in the key column (in this case i am dealing with test data first file with 15 records and second file with 24 records ). i need to merg...

Hi, i did not get any additional information. if i reset and again run it , i got same message Abnormal termination of stage nsar_merge..Merge_transformer detected But what about his second question? Did you reset (not recompile) the job and get any additional messages in the log labelled 'From prev...

Hi,
thanks for ur reply sainath,

this is the only meaage i am getting in the warning .

Sainath.Srinivasan wrote:Is that the only warning or critical message in the log? Did you reset the job to see any info in the log?

Hi , thanks for ur reply i am doing in the same way as you mentioned and the problem is occuring in first row (#1). 0 records are going to transformer. this is the only warning i am getting . 'Abnormal termination of stage nsar_merge..Transformer_1 detected ' thanks . What did searching on this foru...

Hi Everyone, i am merging two files (inner join) , with 2 key columns in both files. i am not doing any tranformation in transformer. i am just loading to sequential file . when i execute the job it is giving following error. Abnormal termination of stage nsar_merge..Transformer_1 detected i could n...

Hi , Silly mistake (Data Mismatch) in this case . I am using Table 1 as look up to load Table2 from same source. when i loaded Table 1 from source , i have done some mathematical manipulation to one of columns (multiply with 1000). when i am trying to load Table2 from same source using Table 1 as lo...

Hi every one.

i got it

Thanks

Hi
Thanks sainath, i will try that

Hi, thanks for ur reply yes i have checked everything what you have mentioned absolutely there is matching between source and hashed file. , meta data is also similar(exactly same) for both input and hashed file. the hashed file is working. i am able to see the data inthe output through View Data. o...

hi Thanks for ur reply 'sainath' Yes , i have loaded table 1. i am uisng Hashed file for look up. Source is Tab delimited flat file. In hashed file output, i am able to see view data. but it is not matchhing with Source .After excecuting job it is showing '0' rows on reference link. What might be th...