Hi,
I have a requirement to survive the most frequent non blank value, incase of tie the latest record based on a date value column should survive.
not able to find a way to pick the latest record value when its a tie. any suggestions ?
Thanks
Search found 149 matches
- Fri May 31, 2013 1:58 am
- Forum: IBM QualityStage
- Topic: Latest record to survive
- Replies: 10
- Views: 8382
- Sun May 12, 2013 5:24 pm
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Suppress Warning\Fatal messages from job log
- Replies: 1
- Views: 7292
Suppress Warning\Fatal messages from job log
Hi ,
I am not sure why the message handler for the IA jobs is not being able to suppress the warning messages.
my question is can message handler handle job logs of IA jobs?
Thanks
I am not sure why the message handler for the IA jobs is not being able to suppress the warning messages.
my question is can message handler handle job logs of IA jobs?
Thanks
- Fri May 03, 2013 1:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: alternative to Oconv
- Replies: 5
- Views: 2072
- Thu May 02, 2013 12:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: alternative to Oconv
- Replies: 5
- Views: 2072
alternative to Oconv
Hi, I was trying to replace the control characters for which oconv does the job: oconv(inputfield, "MCP) However, is there an alternate to this to be done in parallel transformer as I am having trouble with basic transformer timestamp columns. I have tried the Convert function which truncates a...
- Tue Apr 16, 2013 10:19 pm
- Forum: General
- Topic: CDC not able to define subscription?
- Replies: 0
- Views: 486
CDC not able to define subscription?
Hi, Not sure which is the right forum to ask this question I am not able to define subscription in change data capture management console. the menus and the buttons are disabled. there was one subscription previously defined which I am not able to edit. is there something I am not aware of ? Thanks,...
- Mon Mar 05, 2012 9:06 pm
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: not able to maintain persistent stored proc session
- Replies: 0
- Views: 2904
not able to maintain persistent stored proc session
Hi, We have a stored oracle stored proc defined which does an insert and a select at the same time. every time the job gets executed the stored proc log's in to the oracle even if the data doesn't pass through it. this is a web service which gets invoked 100's of thousands time which means each time...
- Tue Feb 21, 2012 6:39 pm
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: expose web services using a shell script
- Replies: 8
- Views: 6409
Hi,
are you are referring to this link? I have a job which I need to run as web service. after compiling the job I have to go to ISD and manually deploy the services. which I want to do it using a shell script without having to do the manual part?
are you are referring to this link? I have a job which I need to run as web service. after compiling the job I have to go to ISD and manually deploy the services. which I want to do it using a shell script without having to do the manual part?
- Tue Feb 21, 2012 5:34 pm
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: expose web services using a shell script
- Replies: 8
- Views: 6409
- Mon Feb 20, 2012 11:52 pm
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: expose web services using a shell script
- Replies: 8
- Views: 6409
- Mon Feb 20, 2012 10:39 pm
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: expose web services using a shell script
- Replies: 8
- Views: 6409
expose web services using a shell script
Hi,
Is there a way to expose the web service using a shell script?
Thanks
Is there a way to expose the web service using a shell script?
Thanks
- Thu Apr 21, 2011 2:35 pm
- Forum: General
- Topic: extract parameters
- Replies: 3
- Views: 1622
Thanks for the reply!! its not about compiling one job or multiple compilation of jobs. Since, we have lots and lots of jobs to verify if there is a parameter change affected in that or not so I am looking for an easier way to find out if all the required parameter definitions are present in all the...
- Thu Apr 21, 2011 11:08 am
- Forum: General
- Topic: extract parameters
- Replies: 3
- Views: 1622
extract parameters
Hi, We struggle a lot when we try to run the jobs the job would hold a set of parameters and in the parameter sets there would be different parameters. and the jobs would abort due to this. as a fix we compile the job and get it running which resolves the issue. However, we would want to correct ide...
- Tue Apr 19, 2011 2:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Avoid looping
- Replies: 3
- Views: 1533
- Tue Apr 19, 2011 1:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Avoid looping
- Replies: 3
- Views: 1533
Avoid looping
Hi, we have a file with variable number of date values(each time the number of rows changes) which define the number of times the loop would run. so, wanted to know is there an alternate way to without having to go through looping method. I am not able to think any alternate way. The reason why I as...
- Mon Feb 21, 2011 11:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: same jobs in multiple projects
- Replies: 2
- Views: 1693
same jobs in multiple projects
Hi All,
I was just wondering if there is a way to use the jobs\meta data present in one project say project1 in project2? we have the meta data and jobs already imported in one project but we have to again import it in the second project. can those jobs be shared?
I was just wondering if there is a way to use the jobs\meta data present in one project say project1 in project2? we have the meta data and jobs already imported in one project but we have to again import it in the second project. can those jobs be shared?