Search found 213 matches
- Tue Sep 17, 2013 2:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Surrogate Key producing one extra key
- Replies: 7
- Views: 3620
- Mon Sep 16, 2013 6:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Surrogate Key producing one extra key
- Replies: 7
- Views: 3620
I have changed the Oracle to Sequential file. SO my job is now Dataset ->> Surrogate Key Stage -->> Sequential file. I ran the Job twice. Surrogate key stage runs in the Sequential mode. I could see that the in the First run the SK is generated from 1 to 475 and in the Next run it generated from 477...
- Thu Sep 12, 2013 10:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Surrogate Key producing one extra key
- Replies: 7
- Views: 3620
In the dataset it is just 475 records and 475 records got loaded to the database. The message is flagged against the surrogate key stage. Also there is one extra surrogate key is getting generated. i.e for the first load say key is generated from 1 to 475 and in the next run it is generating from 47...
- Thu Sep 12, 2013 5:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Surrogate Key producing one extra key
- Replies: 7
- Views: 3620
Surrogate Key producing one extra key
My job looks as follow: Job 1 Dataset --> Surrogate Key Generator -> Oracle Input dataset has 475 Records. When I observed log there is something i could not understand. In the log it shows Output 0 produced 476 records although in dataset only 475 Records are there. can we do anything about this? T...
- Wed Apr 14, 2010 9:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Odbc-Error Codes
- Replies: 0
- Views: 1289
Odbc-Error Codes
Hi,
I am calling SQL Server stored procedure from ODBC stage.
The Problem is even the stored procedure fails the Job complets finished OK.
Please tell me what i need to do to abort the Job when Stored procedure is not finished successfully.
Thanks,
I am calling SQL Server stored procedure from ODBC stage.
The Problem is even the stored procedure fails the Job complets finished OK.
Please tell me what i need to do to abort the Job when Stored procedure is not finished successfully.
Thanks,
- Wed Dec 09, 2009 4:40 am
- Forum: General
- Topic: making jot to run in multiple nodes
- Replies: 3
- Views: 1808
- Tue Nov 10, 2009 5:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SEQUENCE NUMBER GENERATION FUNCTION
- Replies: 5
- Views: 3397
- Wed Aug 26, 2009 6:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Checkpoint from Job Control
- Replies: 4
- Views: 2410
- Wed Aug 26, 2009 4:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Checkpoint from Job Control
- Replies: 4
- Views: 2410
Checkpoint from Job Control
Hi, I have a Job sequence which is Checkpoint enabled. I have a Job Control code to call the Job Sequence. The Job Control code reads the parameter file and sets the parameter to Job Sequence. The Problem i am facing is when i run the Job sequence from job control, the checkpoint does not work. But ...
- Fri Apr 03, 2009 8:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: diff b/w merge and join
- Replies: 7
- Views: 3786
- Fri Mar 13, 2009 9:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC Stage truncating data
- Replies: 14
- Views: 6885
- Thu Mar 12, 2009 4:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: aggregator performance
- Replies: 9
- Views: 3333
- Thu Mar 12, 2009 4:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance
- Replies: 5
- Views: 2681
- Tue Mar 10, 2009 11:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Update query in ODBC
- Replies: 2
- Views: 2309
Update query in ODBC
Hi, I have a pipe delimited file with follwoing column: Countryname oldid newid newname I have the table with following column country id name datetimestamp I have to replace the old id with new id in the table. I am using following query in odbc update <table> set id=?, name=? where country=? and i...
- Sat Feb 28, 2009 9:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem while loading the input file
- Replies: 1
- Views: 1545
Problem while loading the input file
Hi, I have source file in ISO8859-1. But the database is in UTF-8. When i load the file in the database then it is converted to ?. Hence when the data is unloaded from database again for some other process then we get wrong output. Anybody please suggest if this cane be controlled any way? Thanks,