DSXchange

yes we know that we can achive this using just filename with wild card and using this column as key in folder stage to get just filename from folderstage, but his question was for job type parallel..........so the question should go in parallel category.

hello friend can you post your query in parallel category

change the datatype for timestamp column to varchar it will work.

hi warice can you give your input string and what you want in output plus what delimiter you have given in output tab of Row_Splitter stage.

thanks paddu.............it was very good explanation i gained knowledge

first try to replace your '-' with blank..........you will get column as a b c then using stage variable and hash file you will get the required format. job design seqfile--------->T1-------------->T2---------->HASHfile in T1 do trim(ereplace(input.col1,"-","")) in T2 do concat u...

Example: gcc -o program_name.cpp program_name
then you can call your object code from after job subroutine ..........

i have not tried using folder stage .............but may be you can use it if you know the file in folder to get transfered. to transfer a file from seq file stage you have a design like seq file------------transformer--------------------->FTP stage. check for ftp stage input tab properties properly...

Please can you mark the topic as resolved.

try below

Oconv(Iconv(DSLink22.ATS270_CARD_EXPIRY[1,2]:'/':DSLink22.ATS270_CARD_EXPIRY[3,4],"D2/ MY"),"D-DMY[2,A3,4]") it will give output like "01-MAY-2008", as date is not specified in your requirement it will always be 1st date of month.

Just convert your input 0823 into 08/23 like "MM/YY" ........Then use OCONV(ICONV("05/08","D2/MY"),"D/E") to give you date in your format....check for oconv for various formats.......using proper format you can insert it into oracle database. OCONV(ICONV("...

you are try to implement Slowly changing Dimension..........

one question can clear the implementation...............

how do you determine that company_id=1, product=a and price of 10 need to have end date 31/1/07

sorry for my previous post

also @PATH system variable can you the information.

if it is a custom transform routine then in transformer or otherwise in job control interface