Search found 155 matches
- Tue Jul 11, 2017 7:48 am
- Forum: Cognos (IBM BI)
- Topic: Framework Manager - Cognos
- Replies: 0
- Views: 15423
Framework Manager - Cognos
Hello Gurus I am new to Cognos 10.2 - have some basic expereince in FM . The scenario is that there is a report requirement which needs to check for key change in a perticular column and within the group of same key rows - do a few checks based on certain date columns and create a new column to flag...
- Fri Jul 15, 2016 12:22 pm
- Forum: General
- Topic: Fallen Premium Poster: Kim Duke
- Replies: 32
- Views: 26864
- Thu Jul 07, 2016 7:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hierarchial Data
- Replies: 2
- Views: 5912
Hierarchial Data
Hello all, I am currently using "Hierarchical Data" stage in order to split the xml files into multiple files based on Batch Split Key. In order to create XML's I need to default certain fields in addition to get data from input (database) and few calculation fields (in transformer) Issue ...
- Wed Jul 06, 2016 7:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: timestamp format
- Replies: 11
- Views: 9269
- Tue Jul 05, 2016 9:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: timestamp format
- Replies: 11
- Views: 9269
- Tue Jul 05, 2016 8:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: timestamp format
- Replies: 11
- Views: 9269
- Fri Jul 01, 2016 11:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: timestamp format
- Replies: 11
- Views: 9269
- Fri Jul 01, 2016 10:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: timestamp format
- Replies: 11
- Views: 9269
timestamp format
Hello everyone I wanted to know if there are any direct ways to change the timestamp format (Tried doing in job properties) but it didn't work file-transform-file StringToTimestamp(TimestampColumn,"%yyyy-%mm-%dd %hh:%nn:%ss") is the standard format for any string to timestamp conversion Bu...
- Thu Jun 30, 2016 10:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformation Logic
- Replies: 6
- Views: 6089
- Thu Jun 30, 2016 8:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformation Logic
- Replies: 6
- Views: 6089
Thank you for the pointers However , the scenario (I think) is slightly different . Col 1 values above are calculated based on row numbers (a different requirement) , for example lets say I am calculating the value of Col 1 as floor(row number/5) in a stage variable . As a result of that first 5 rec...
- Wed Jun 29, 2016 3:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformation Logic
- Replies: 6
- Views: 6089
Transformation Logic
Hello all, I have a job that does some calculations based on row numbers , lets say Column A has these values , I want another column B which counts based on change in value of A So Input say Column A , Column B 1 , 1 1 , 2 2 , 1 2 , 2 2 , 3 55 , 1 55 , 2 95 , 1 98 , 1 Basically Column B is a counte...
- Mon Nov 16, 2015 11:24 am
- Forum: General
- Topic: Compare jobs across projects
- Replies: 2
- Views: 3143
Compare jobs across projects
Hello
I am trying to see if there is a way to compare jobs available in say one project to another , if yes , will that also apply for jobs in different servers - This would be useful when you migrate jobs in steps .
Thank you
I am trying to see if there is a way to compare jobs available in say one project to another , if yes , will that also apply for jobs in different servers - This would be useful when you migrate jobs in steps .
Thank you
- Thu Oct 22, 2015 9:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date conversion from String
- Replies: 4
- Views: 4103
- Thu Oct 22, 2015 8:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date conversion from String
- Replies: 4
- Views: 4103
- Thu Oct 22, 2015 8:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date conversion from String
- Replies: 4
- Views: 4103
Date conversion from String
Hello All, I have a simple operation where I am converting a 8 digit varchar string into date and then validating if the date is a valid date. So the job is dataset->transformer->dataset The issue ; One of the input string is '09001972' (MMDDYYYY Format) , so when I first convert into date it throws...