DSXchange

Hi, I have this wierd requirement, i dont know if the table was designed wrong, but my process is aborting due to this reason. I have field as Integer(2), from flat file and that is staraight drop in to table into a filed which defined as decimal(2,2), in transformer i directly gave as decimal(2,2) ...

Hi ,

I tried ti find the answer by searching in the fiorum but was in vain,

I have thsi varchar(1) in transformer, and Bit in database table, which conversion whould i need to use

Hi, In transformer am writing down a text, but i want some of the strings of teh text to be bold? is there a fucntion to taht?

I am reading thropugh LS command now,

tahnsk, they can be sorted on date, i missed taht

I have six files , i am reading in file pattern manner, files will ahve this names BLG_LB_ 010213 .txt,BLG__SA_ 010213 .txt,BLG__AD_ 010213. txt, but for some reason if my etl process doest run, there will be 6 files now , 3 with previous day, and 3 new from current date,BLG_LB_ 010313 .txt,BLG__SA_...

Hi, currently my output is thsi way: CLIENTID RECORDTYPE EMPNO GroupPolicynumber ABC101 A1 ABC101 A2 ABC101 A2 ABC101 A3 ABC101 A4 ABC101 A4 ABC101 A5 ABC101 A5 ABC101 B1 7990778998 ABC101 B1 7990789734 ABC101 I1 7990778998 457893275B ABC101 I1 7990778998 879765992A ABC101 I1 7990789734 JHJU898977 A...

Ia m reading such 3 files, so read in file pattern manner, and there would be one long log record. YES as one column.

Hi, I am reading a file with multiple records.Each column in a single record is TAB delimated. the input file looks like this below:(the space btw is TAB) FH column1 column2 column3 BH Column1 Column2 Column3 DS Column 1 Column2 Column3 DL...etc. To read each column i gave this logic in transformer ...

thanks chulett, i think i should give node constraint.

Hi, I have multiple files reading in using file pattern method,along with filename, in the output i am having batch header record(BH) and in that record, the second field should represent the number of the file. what logic shall be written in transformer(4 node transformer), example, if i have 6 fin...

tahnks all, i used Field instead

what are periods and how can i use them, ?

I have 3 differetn files with same format, they have , FH,BH,DL,SA,CC,BT,FT records, i have to pass them to seven different files which have only taht record along with their filenames, in transformer what condition should i put in order to make the records go into only those respective link, if it ...