Search found 74 matches
- Thu Oct 25, 2012 9:02 am
- Forum: General
- Topic: Job compiled but not visible in director
- Replies: 12
- Views: 10185
- Thu Oct 25, 2012 4:35 am
- Forum: General
- Topic: Job compiled but not visible in director
- Replies: 12
- Views: 10185
- Thu Oct 25, 2012 3:37 am
- Forum: General
- Topic: Job compiled but not visible in director
- Replies: 12
- Views: 10185
Job compiled but not visible in director
Hi, I am trying to compile some parallel jobs & sequencer jobs (Multi Instance Jobs) in my datastage environment wherein the designer is showing that the job is compiled successfully but when I check the same job in director it is showing as Not Compiled job. I would like to highlight one point ...
- Tue Jun 12, 2012 10:11 pm
- Forum: General
- Topic: Datastage project wise folder name
- Replies: 3
- Views: 2747
- Tue Jun 12, 2012 5:55 am
- Forum: General
- Topic: Datastage project wise folder name
- Replies: 3
- Views: 2747
Datastage project wise folder name
Hi, I have written a DS sub-routine to get the job wise Category/Folder name & writting into a sequential file. following is the query I am using for this purpose: SELECT JOBNO FMT '5L', NAME FMT '100L' AS JNAME,CATEGORY FMT '100L', JOBTYPE FMT '5L' FROM DS_JOBS WHERE NAME NOT LIKE '\\%'; I trie...
- Thu Mar 03, 2011 1:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hierarchical Logic implementation
- Replies: 1
- Views: 1842
Hierarchical Logic implementation
One of my source table have some fields & i need to get hierarchical relationship beteen two of the columns. For example there are two fields in the table ID & SubID and they have relationships like ID SUB_ID OtherFields 101 102 ----- 102 103 ----- 103 104 ----- 104 105 ----- 105 105 ----- A...
- Mon Jan 31, 2011 5:11 am
- Forum: General
- Topic: Matching the records
- Replies: 4
- Views: 3145
- Thu Jan 27, 2011 11:43 pm
- Forum: General
- Topic: Matching the records
- Replies: 4
- Views: 3145
- Thu Jan 27, 2011 11:32 pm
- Forum: General
- Topic: Matching the records
- Replies: 4
- Views: 3145
Matching the records
Hi All, I am having some 1 millions of records(Source) having 4 fields and I have another reference table of 3 fields containing some 6-7K of records. The structure of Source table is something like: Field1, Field2, Field3, Field4 004960239674199,4921316782,SI025308,LNAZHADE 0034918382252,5939793841...
- Tue Oct 26, 2010 3:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading one Dataset multiple times in parallel job
- Replies: 3
- Views: 2339
- Sun Oct 24, 2010 11:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading one Dataset multiple times in parallel job
- Replies: 3
- Views: 2339
- Sun Oct 24, 2010 10:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading one Dataset multiple times in parallel job
- Replies: 3
- Views: 2339
Reading one Dataset multiple times in parallel job
Hi, My requirment is to replicate the logic of oracle user defined function into datastage and my database is netezza which does not support these types of user defined functions. So for that i have prepared one parallel job for achieving the same thing with the help of DS job but because of the bus...
- Tue Aug 03, 2010 9:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to Read from/Write to OMD.XML.DIR
- Replies: 1
- Views: 4757
Unable to Read from/Write to OMD.XML.DIR
Hi All, I am having one server job which is reading csv file and writing into another temporary sequential file. This particular job normally used to take 15-20 min to do complete processing but since morning, When i am running the job it is continously in the running state. The job is generating wa...
- Thu May 06, 2010 5:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need some info on logic
- Replies: 7
- Views: 3598
Basically idea behind this requirment -> As this is monthly job, the data will be loaded into target table (appended) on monthly basis. So let`s say after loading this data, if there is any indication that the base ref data is somehow not perfectly correct so after getting the corrected ref data tab...
- Thu May 06, 2010 4:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need some info on logic
- Replies: 7
- Views: 3598