Search found 170 matches
- Thu Feb 18, 2016 6:16 am
- Forum: IBM QualityStage
- Topic: Investigate Reports
- Replies: 12
- Views: 30968
Investigate Reports
Hi, I am new to QualityStage, So i just started learning by using the IBM QualityStage Tutorial and dsx with the given csv file. I ran Investigate job which does investigation on Name, Geographical details (City, Stage, Zip, etc.). Job has run successfully and it has created 3 csv reports. So I want...
- Wed Sep 23, 2015 9:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SQL Server Deadlock Error
- Replies: 11
- Views: 7151
- Wed Sep 23, 2015 8:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SQL Server Deadlock Error
- Replies: 11
- Views: 7151
- Wed Sep 23, 2015 4:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SQL Server Deadlock Error
- Replies: 11
- Views: 7151
SQL Server Deadlock Error
Hi I am trying to do Upsert on Sql Server table. But it is giving a deadlock error as below. I am running the parrel Job and ODBC stage also running in parallel. ODBC_Target,2: ODBC function "SQLExecute" reported: SQLSTATE = 40001: Native Error Code = 1,205: Msg = [IBM (DataDirect OEM)][OD...
- Sat Sep 05, 2015 6:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null Representation
- Replies: 5
- Views: 3699
- Fri Sep 04, 2015 9:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null Representation
- Replies: 5
- Views: 3699
- Fri Sep 04, 2015 9:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null Representation
- Replies: 5
- Views: 3699
Null Representation
Hi I am facing an issue with Null Values in integer field from file. What i am doing here is I am validating the null value using If (IsNull(lnk_In.col1) or trim(lnk_In.col1)="") Then "NULL" Else "NONNULL". then i put condition while loading into table only to move the ...
- Mon Jul 13, 2015 9:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Update 20m rows table
- Replies: 6
- Views: 4804
- Mon Jul 13, 2015 7:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Update 20m rows table
- Replies: 6
- Views: 4804
Update 20m rows table
Hi
I have table which has over 20million rows in it. In Source System, many rows (over 30%) are updated every day. I am using Upsert method in datastage. It is taking more time for upsert.
Is there any other method we can use to get the performance?
Thanks
I have table which has over 20million rows in it. In Source System, many rows (over 30%) are updated every day. I am using Upsert method in datastage. It is taking more time for upsert.
Is there any other method we can use to get the performance?
Thanks
- Fri Mar 06, 2015 5:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential File Issue
- Replies: 0
- Views: 2104
Sequential File Issue
Hi Source Systems have generated files with the below format Record Delimiter: LF Field Delimiter: | Quote: None Character Set - UTF-8 I am trying to load the file into Database table using Parallel Job it gives warning saying that Seq_SourceFile,0: Missing record delimiter " ", saw EOF in...
- Tue Feb 17, 2015 6:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sql Server Bulk Load
- Replies: 2
- Views: 3036
Sql Server Bulk Load
Hi I am using Bulk Insert in DRS Connector for SQL Server Database. I have executed the two Jobs one with ODBC Connector and Other with DRS(Bulk Insert) But i couldn't see any difference in execution time of both. I had seen all logs and both are pretty similar. Can someone tell me how to find my jo...
- Thu Jan 08, 2015 5:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Escape Character
- Replies: 6
- Views: 6568
- Tue Jan 06, 2015 11:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Escape Character
- Replies: 6
- Views: 6568
Escape Character
Hi We receive delimited flat files in which content has delimiter symbol(|) for few rows. to mitigate this issue, source people has created flatfiles with escape character wherever you have delimiter symbol(|). I tried finding the solution in Sequential stage but no luck. Can someone advise on this ...
- Wed Oct 29, 2014 2:00 pm
- Forum: General
- Topic: How to change the user in executing the datastage
- Replies: 4
- Views: 3041
- Tue Oct 28, 2014 1:39 pm
- Forum: General
- Topic: How to change the user in executing the datastage
- Replies: 4
- Views: 3041
How to change the user in executing the datastage
Hi
when i execute Datastage it is using my login id to execute the Job. Is there any way to set up that it should use dsadm account?
thanks
when i execute Datastage it is using my login id to execute the Job. Is there any way to set up that it should use dsadm account?
thanks