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.
Search found 59 matches
- Wed Sep 13, 2017 8:59 am
- Forum: General
- Topic: ETL Job rowcount and other details
- Replies: 8
- Views: 7206
- Wed Sep 13, 2017 6:45 am
- Forum: General
- Topic: ETL Job rowcount and other details
- Replies: 8
- Views: 7206
- Wed Sep 13, 2017 6:33 am
- Forum: General
- Topic: ETL Job rowcount and other details
- Replies: 8
- Views: 7206
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...
- Tue Sep 12, 2017 2:43 pm
- Forum: General
- Topic: ETL Job rowcount and other details
- Replies: 8
- Views: 7206
ETL Job rowcount and other details
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...
- Thu Sep 07, 2017 1:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove multiple Ascii characters from input data
- Replies: 12
- Views: 11029
- Thu Sep 07, 2017 10:17 am
- Forum: General
- Topic: Unable to view Ray's comment as a Premium Member
- Replies: 5
- Views: 2423
- Thu Sep 07, 2017 10:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove multiple Ascii characters from input data
- Replies: 12
- Views: 11029
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...
- Thu Sep 07, 2017 6:59 am
- Forum: General
- Topic: Unable to view Ray's comment as a Premium Member
- Replies: 5
- Views: 2423
- Thu Sep 07, 2017 6:56 am
- Forum: General
- Topic: Unable to view Ray's comment as a Premium Member
- Replies: 5
- Views: 2423
Unable to view Ray's comment as a Premium Member
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
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
- Thu Sep 07, 2017 6:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove multiple Ascii characters from input data
- Replies: 12
- Views: 11029
- Wed Sep 06, 2017 12:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove multiple Ascii characters from input data
- Replies: 12
- Views: 11029
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 ...
- Wed Sep 06, 2017 12:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove multiple Ascii characters from input data
- Replies: 12
- Views: 11029
Remove multiple Ascii characters from input data
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...
- Tue Sep 05, 2017 8:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove ASCII Code 160 in transformer
- Replies: 8
- Views: 6210
- Fri Sep 01, 2017 7:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequence number using Surrogate Key in transformer
- Replies: 6
- Views: 6329
- Thu Aug 31, 2017 10:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove ASCII Code 160 in transformer
- Replies: 8
- Views: 6210