DSXchange

I have a TAB delimited txt file that I saved using TOAD it has more than 65000rows so i cannot save it using .CSV extension how do i load this file using the flat file stage Basically what will be the valus of the DELIMITER Box in the output / Format tab on the flat file stage properties. for EG .CS...

DSguru2B

that worked !!

thanks!!

rxs0005

hi all the logic is like this BALLOON_INDICATOR = 'Y' if PRODUCT_TYPE like '%alloon%' I have translated it to the below in the Transformer it does not seem to work If tpo_loan_orig_out.PRODUCT_DESCRIPTION Matches "%alloo%" Then "Y" Else "N" i also tried If tpo_loan_orig...

All Simple rrequest Sequntial file has 2006-02-28 00:00:00 i need to put it in ORacle DATE feild how do i do it Also I have defined the date column on the orcale side in DS as TImestamp 38 Do i have to define it as TIMESTAMP in the metadata defenition on the SEQ stage or is it ok to be varchar thank...

is there a way / work around , after we do the mapping we can sort the columns in the transformer as with many cols its really very difficult to search for them .



thanks
rxs0005

hi I have sequential text files that have $ amounts prefixed to the value and there are several columns. How do i strip them before i laod them to orcale tables. Should i define the COLA under seq stage as varchar2 and in oracle as a regular number(8,3) EG: Col A ColB ( in oracle ) $4455.444 4455.44...

all

Thanks, for now i will just do an Update in the after SQL tab in the Oracle stage this Date airthmetic is too complicated for me to research now i will just use the Oracle date math functions and update the table

thanks for the info

rxs0005

Hi based on the above equation i did the below iconv(tpo_loan_orig_out.MATURITY_DATE, "DDMY") - iconv( tpo_loan_orig_out.NOTE_DATE, "DDMY") both the dates are stored in the DD-MON-YY format eg: 03-AUG-05 the output of this is 0 can some one tell me what am i missing do i have to ...

hi all I need to to date math like this ( (Date1 - Date2 ) * 360 ) / 12 I can do this in oracle very easily like below ROUND((Date1 - Date2 ) / 365 ) * 12 also Date1 > Date2 how do i do this in the transformer using date function provided by datastage. I think finally what i need is a function that ...

hi all i am trying to use sting decode i have the 3 versions it still does not change it on DB the input is VARCHAR2(10) i.e data type of PROPERTY_TYPE StringDecode(tpo_loan_orig_out.PROPERTY_TYPE,'01=Condo under five stories|1=Condo under five stories') StringDecode(tpo_loan_orig_out.PROPERTY_TYPE,...

thanks that worked!

hi all All i need to do is i have a column that is 5 characters long . I need to LPAD it with 0's if its not 5 characters long Input col = ABCD OUTPUT = 0ABCD Input col = ijklm OUTPUT = ijklm basically the oracle LPAD equivalent . I found the PadString function Return the string padded with the opti...

hi i am using this in the transformer StringDecode( tpo_loan_orig_out.OCCUPANCY , 'O= OwnerOccupied|N =Non Owner Occupied| S= Second home ' ) but when the input is O its not decodign to OwnerOccupied as i am gettgin the below inf in the log file bnk_ld_gmacb_loan_orig..xfm_bank_tpo_loan (StringDecod...

Kc

thanks i had a Q regarding CONVERT instead of hard coded values i can substitute a column name form the same table right for eg:

update table
set col_X = decode(col_x, null, col_Y , 0, col_Y, col_X )

thanks

R

hi all,

I need to do an transformation based on DECODE logic i use in oracle

in the TRANSFORMER which fucntion / routine i use

thanks

eg:

update table
set col_X = decode(col_x, null, ABC, 0, ABC, col_X )