Search found 152 matches
- Thu Sep 10, 2009 12:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: remove duplicates using Transformer
- Replies: 6
- Views: 1951
Thank you much, you are right I tested with only key 1 and key 2 and it worked just fine, removing the duplicates. I guess I has to use remove duplicate stage and retain the first record. After the transformer stage I will use the same partitioning in the remove duplicate stage and retain the first...
- Thu Sep 10, 2009 10:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Removing both duplicates
- Replies: 4
- Views: 1751
Re: Removing both duplicates
I have a requirement in which if a duplicate value occurs in a particular field, I need to drop both (or all) of the records with that value. I'm guessing there may be a sql statement that could be devised to handle this, but I'd like to do it without that if possible. Anyone have suggestions? Than...
- Thu Sep 10, 2009 8:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Close command : parallel
- Replies: 9
- Views: 2163
- Thu Sep 10, 2009 8:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Close command : parallel
- Replies: 9
- Views: 2163
- Mon Apr 13, 2009 11:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Maximum length of SQL in Oracle query
- Replies: 11
- Views: 4617
- Mon Apr 13, 2009 10:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Maximum length of SQL in Oracle query
- Replies: 11
- Views: 4617
Re: Maximum length of SQL in Oracle query
check the column names you gave in the colums tab. you are using union.. in the first query the first column is emp.a in the second query it is emp1.a use a common column name like this select emp.a as a ,emp.b as b ,emp.c as c from table emp union select emp1.a as a ,emp1.b as b ,emp1.c as c from t...
- Wed Apr 01, 2009 8:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Convert string to numeric value
- Replies: 2
- Views: 3906
Re: Convert string to numeric value
I this is happening since u have Filed Marks in the Execute Command output...
when assigning the output to the Job parameter, remove the the FM.
when assigning the output to the Job parameter, remove the the FM.
Code: Select all
Convert(@FM,'', Execute_Command_7.$CommandOutput)
- Thu Mar 26, 2009 7:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error : Invalid number ORA-01722
- Replies: 4
- Views: 4295
- Wed Mar 25, 2009 5:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datetime on Sequential File
- Replies: 4
- Views: 2395
Re: Datetime on Sequential File
are you writing file to file??? or from file to a DB table???
- Wed Mar 25, 2009 3:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedure fails with incorrect SET options
- Replies: 10
- Views: 4130
- Wed Mar 25, 2009 1:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Copy of Datasets in different environment
- Replies: 3
- Views: 1817
Re: Copy of Datasets in different environment
you can write that data set to a seqential file on prod and copy it to test.
before you run the job write from seq file to a dataset on test.
may be an option atleast.
before you run the job write from seq file to a dataset on test.
may be an option atleast.
- Wed Mar 25, 2009 1:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Inserts
- Replies: 21
- Views: 6615
- Wed Mar 25, 2009 9:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Inserts
- Replies: 21
- Views: 6615
- Wed Mar 25, 2009 9:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Inserts
- Replies: 21
- Views: 6615
- Wed Mar 25, 2009 9:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Inserts
- Replies: 21
- Views: 6615