DSXchange

Concatenate columns 1 to 10 in both source and lookup then perform the lookup based on the concatenated column

Recently I have had the same issue ie after adding APT_ORACLE_PRESERVE_BLANKS all the character columns have been padded with space. I have found a workaround for this, just updating the old thread which may help others. Workaround Removed length values in the metadata for all the columns in the loa...

Read it as a single varchar column with out any lenght.In transformer put a constraint like length(column)>(take the total metadata length sum) then reject it


-Paul

Use DRS satge to read the data as varchar in transformer convert using the function and change datatype as nvarchar .

Whats your source and datatype used for reading? Are you checking in view data or table?

whats the value looks like in the table after applying this funcation .

Make sure that datatype is in nvarchar

Split the job as two separate jobs ,after join write into a dataset

Use stringtoUstring(colunname,'UTF-8') with column datatype as nvarchar

Regards,
Paul Joseph

Sorry , I haven't noticed your comments , I know that the post doesn't have much explanation of the requirements .

Apply stringtoUstring(columnvalue,'UTF-8') and make column datatype as nvarchar

View data wont give the correct result ,please check the final out put (file or table)


Thanks
Paul Joseph

Can you try to pass it as stringtoUstring(columnvalue,'UTF-8')

Create a column called Productive_time in transformer with value as Out_time-IN_Time Emp_id IN_Time Out_time Productive_time 1234 09:30 10:30 1 1234 11:00 14:00 3 1234 15:00 17:00 2 1234 17:30 18:30 1 pass this to an aggregator stage group with Emp_id and calculate min(in_time),max(out_time),sum(Pro...

Thanks craig for reply . We are using datastage 7.5.2 ,see the below complex falt file settings Charcter Set -EBCDIC Byte Order -Native-endian Data Format-Binary Record type -Variable. The file is in variable format also conatins an array STATUS OCCURS 1 TO 82 TIMES DEPENDING ON STATUS-COUNT. how ca...

We are facing issue with reading EBCDIC file using complex flat file stage. We have received the file with both ASCII and binary format .ASCII file is readable other than few lines because of one of the COMP-4 field contains binary data 10(decimal 10, hex value 0A) and in UNIX it converted as line f...

Read as a single varchar column, use convert function to replace 'space' into 'comma'(or any other) ,use column import to parse this into multiple columns


-Paul