DSXchange

Hi Craig / Mike/ Paul,

I went through the documentation, it was very useful. But in our environment they didn't build/configured the DSODB database and not ready to do so.

Is there any other way to get the information without DSODB.

Thanks.

Thanks, Craig. I will look into it.

Thanks for your reply, Mike. As you said, I went through this website 'https://www-304.ibm.com/support/docview.wss?uid=swg21509567' and I checked the file 'D:\IBM\InformationServer\Server\DSODB\logs\AppWatcher_Cmd. AppWatcher_Cmd has the contents like below 2017/08/03 21:10:15: DSODB is currently tu...

I have a requirement that once the job got finished, it should populate the JOB_NAME, PROCESS_EXECUTION_ID, PROCESS_START_DATE, PROCESS_END_DATE, PROCESS_DURATION, ROWCOUNT_EXTRACTED, ROWCOUNT_INSERTED, ROWCOUNT_UPDATED, ROWCOUNT_ERROR into a table called D_ETL_AUDIT_JOB_LOG. Say for example, if I h...

Thank you UCDI for your valuable suggestion.

Oh...Thank you, Craig.

The problem is resolved I checked Ray's post ( Line Breaks in the flat files ) and find the clue. It worked. Steps 1)Created 3 stage variables svChar160 - Char(160,@TRUE) svChar191 - Char(191,@TRUE) svChar194 - Char(194,@TRUE) 2) Transformation rule in transformer Convert(svChar160:svChar191:svChar1...

I think there is glitch in internet connection. Now I am able to see Ray's comments.

Hi,

Though I am a premium member and logged in , I am unable to see Ray's comment in this topic 'Line Breaks in the flat files'


Why is it so? Please let me know.

Thanks,
Sujatha

Thank you, UCDI.

Your solution is a bit confusing for me. I want to use ereplace or convert to remove multiple ascii characters.

I don't know what mistake I am doing in the syntax of Convert for handling multiple ascii characters

Hi Craig, Source application team can't provide quality data. They told to remove the ascii characters using datastage and load into target. In normal source oracle database, we can't see ascii characters. So using the export wizard, I uploaded into csv file and through eyecheck I found char values ...

Hi, I have a requirement to remove multiple ascii characters from the input data. Eg- input data has below values column name - Description ================== Paratransit¿Web-Based¿Trip¿Boo TRE DFW ROW Maintenance Tie Re Input data length - char (30) Output data length - Varchar...

Thank you Ray and Craig. I will get back to you on this

Thanks for your reply, Glover.

Thanks Craig. I will try and get back to you.