Search found 55 matches
- Fri Mar 15, 2013 1:16 am
- Forum: General
- Topic: Automate to run 3 jobs as and when available.
- Replies: 6
- Views: 2439
Hi All, Prasson, Thanks a lot for you effort, can this be done in one sequence if not I will convince them to have 3 seq one for each job startloop----> waitforfile------>JobA ---->ExecCommand---->EndLoop I want to run the job between 6 am to 8 pm. As per your approach the job will start and it will...
- Fri Feb 22, 2013 6:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with constraint in Transformer
- Replies: 5
- Views: 2375
- Fri Feb 22, 2013 4:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with constraint in Transformer
- Replies: 5
- Views: 2375
- Fri Feb 22, 2013 4:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with constraint in Transformer
- Replies: 5
- Views: 2375
Issue with constraint in Transformer
Hi, My Target are sequential file. Before target i have a transformer and from Transformer I have 5 out put links (my target files) Suppose My transformer is T and out put link are A,B,C,D,E. There is a constraint for each out put link. Out of the 5 constraint 3 are same (say constraint for link A,B...
- Wed Jan 09, 2013 3:26 am
- Forum: General
- Topic: Routine Statement not understood
- Replies: 4
- Views: 1731
- Wed Jan 09, 2013 2:15 am
- Forum: General
- Topic: Routine Statement not understood
- Replies: 4
- Views: 1731
Routine Statement not understood
Hi All, I have started working on routine , I was trying to debug few that are already available in my project. I understand what it is doing, but there were few statements that I have not understood and they are 1) Common /SDKStringDecode/ Initialized, ValueArray, LookupArray 2) Difference between ...
- Sat Mar 10, 2012 2:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can it be possible to calculate sum of salary and number of
- Replies: 3
- Views: 1643
Can it be possible to calculate sum of salary and number of
Hi I was trying to implement a senario where i have in comming data from a dataset. I am trying to do this with one aggregator stage Empno Deptno Salary 1111 10 200 2222 20 300 3333 10 400 4444 30 400 5555 20 400 6666 10 400 oupt put Deptno Sum_Salary Mem_count 10 1000 3 20 700 2 30 400 1 Regards Ma...
- Thu Aug 18, 2011 7:14 am
- Forum: General
- Topic: Retrive a vlaue from one job and use that in a different job
- Replies: 2
- Views: 1665
Retrive a vlaue from one job and use that in a different job
Retrive a vlaue from one job and use that in a different job while reading from source, In detail I am reading from a table (oracle) and writing to a dataset (or if suggested can be a seqential file). From table i am select just one column for a max(vlaue) in the where condition and it is retrieving...
- Wed Aug 17, 2011 11:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: execution mode for Oracle Enterprise stage
- Replies: 3
- Views: 2246
Thanks a lot Ray.. So you are saying if source table is partition then only the source stage execution mode will be parallel. else it will run in sequential mode. Is there any way to read the table (not partition) in parallel execution mode, This task i am doing for performance improvement. Table pa...
- Wed Aug 17, 2011 4:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: execution mode for Oracle Enterprise stage
- Replies: 3
- Views: 2246
execution mode for Oracle Enterprise stage
Hi All, I am reading from Oracle Enterprise stage and writing to dataset stage. My question is related to execution mode of the stage. Here i am trying to explain my job design. I have 2 different flows in the same pallet reading from 2 different table Oracle --> Transformer stage --> Dataset satge ...