DSXchange

Hi, My source is 2015-01-26 00:00:00 (Timestamp in hash file) I need to load to Oracle database datatype is DATE. SELECT sysdate from DUAL; 06-FEB-15 I have tried with few options OCONV(Iconv(Left(col1,10),'D-YMD'),'D4-YMD[4,2,2]') Everytime is get this error Attempt to convert String value "20...

Thanks for reply, let me check and get back.

Hi,

Any idea how do I convert yyyyy-mm-dd to DD/MM/YYYY in server jobs.

Source column is Timestamp and output column is DATE.

Any thoughts.

Thanks,

Thanks for the the reply, it was a environment issue.

Thanks,

Hi, Got a job Oracle stage -> Hash file When I compile the job and run, it gives me the no. of rows processed as 256, but sometimes, it shows me no of process as 20 rows only, when run from sequencer. In the source no. of rows are 256. No error logs or warning coming. In the Oracle stage it's a simp...

Thanks guys,

Our source was SQL server, we did a CAST statement in the source query, did not do any datetime format conversation.

Thanks,

No, its not interview question.

Thanks,

Hi Guys, Need to check the format of the incoming values is YYYY-MM-DD HH:MM:SS.XXX I need to find the last 3 digits i.,e XXX if it exists I need to take the left 19 digits. My source is SQL server and column is Nvarchar and the output column is also nvarchar. 2011-07-01 00:00:00.000 2010-10-05 00:0...

Thanks guys for the replies..

The awk command is working fine, will check the extra spaces, Thank you.

Hi, Have tried the option of awk Without the awk command, iam getting the below output. Job_No;65 # 1 blank line Sequence[1;2] Job_no;1 With the awk command, iam getting the below output. Job_No;65 # 1 blank line # 2nd blank line is coming Sequence[1;2] Job_no;1 #Blank line is coming How to remove t...

Thanks for the replies.

@Ray Before and after job commands are not in the company standards.

@Anbu, i will try this option now.

Thanks,

Hi Guys, Need 1 help to generate a blank line in the output file at end. Job desgin External_source_1 External_source_2 -> Funnel -> Sequential Stage Row_Generator Iam getting the output, the only issue is need a blank line in the output file at the end. Any help would be appreciated. Thanks,

Thank you for the replies.

nightly backups, we still in development phase, but when from the sequence all the jobs get successfull completed.

Will check out the option syncproject.sh and update you.

Thanks,

Hi Guys, Please need your help, while exporting a Folder from the Export option, Iam getting the below error. An unhandled exception has occurred in a component in your application. Click continue and application will ignore this error and attempt to continue. Object reference not set to an instance...