Search found 86 matches
- Tue Mar 19, 2013 5:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Looping Aggregation
- Replies: 3
- Views: 3300
As number of installements will be veried on each account therefore join stage will merge the records based on account number and later on calculation will be applied in transformer stage as per my example. Actually, i like your solution more with sort stage and tested the data it works for this req...
- Mon Mar 18, 2013 9:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Looping Aggregation
- Replies: 3
- Views: 3300
Datastage Looping Aggregation
Hello Friends, Need your input to create better datastage design. Well let me tell you my input data and what i want to achieve from input data. Input Data Installment AcctNumber Earned Interest Total Interest 0 abc 17.09066667 1237.2 1 abc 37.88133333 1237.2 2 abc 39.86433333 1237.2 3 abc 36.711666...
- Wed Aug 27, 2008 2:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Metadata Problem while extracting from oracle 9i table
- Replies: 5
- Views: 2468
- Wed Aug 27, 2008 12:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Metadata Problem while extracting from oracle 9i table
- Replies: 5
- Views: 2468
- Tue Aug 26, 2008 6:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Metadata Problem while extracting from oracle 9i table
- Replies: 5
- Views: 2468
Metadata Problem while extracting from oracle 9i table
Hi All, Could you pleaese guide me on following issue of metadata : While extracting data from oracle(9i) table , getting following warning messages : 1) Orcl_Valid_Stat_Extract: Column SEQUENCE_JOB_ID floating point decimal is not fully supported; adjusting the scale. 2) Orcl_Valid_Stat_Extract: Wh...
- Tue Jul 15, 2008 1:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: days_since_from_date
- Replies: 2
- Views: 2848
days_since_from_date
Hi All, Have requirement of to get number of days between two dates, have used date format as yyyy-mm-dd in DaysSinceFromDate function . While running datastage job , getting few warnings like : "DW_AcctArrg_Tfm1,4: Conversion error calling conversion routine days_since_from_date data may have ...
- Wed Jan 30, 2008 3:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparision between Px Transformer & Pivot stage
- Replies: 4
- Views: 2530
Comparision between Px Transformer & Pivot stage
Hi All,
There is a requirement to load large amount of data and for that i need some inputs on pivot stage and parallel transfer stage, which one is most faster !!
could any guide me comparison between pivot stage and px transformer stage.
Appreciate you help !!
There is a requirement to load large amount of data and for that i need some inputs on pivot stage and parallel transfer stage, which one is most faster !!
could any guide me comparison between pivot stage and px transformer stage.
Appreciate you help !!
- Tue Oct 03, 2006 6:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: dsjob command not found
- Replies: 4
- Views: 9106
- Tue Oct 03, 2006 6:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: dsjob command not found
- Replies: 4
- Views: 9106
dsjob command not found
Hello,
In ....DSEngine/bin directory dsjob command is available however i am trying to use dsjob command at that time i am getting
"dsjob: command not found"
have set the appropriate library path also , but still i can not use dsjob command.
pls suggest your ideas on same.
Regards,
Hiten
In ....DSEngine/bin directory dsjob command is available however i am trying to use dsjob command at that time i am getting
"dsjob: command not found"
have set the appropriate library path also , but still i can not use dsjob command.
pls suggest your ideas on same.
Regards,
Hiten
- Tue Oct 03, 2006 4:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warning Msg in wrapper stage job
- Replies: 6
- Views: 2534
- Tue Oct 03, 2006 3:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warning Msg in wrapper stage job
- Replies: 6
- Views: 2534
- Tue Oct 03, 2006 2:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warning Msg in wrapper stage job
- Replies: 6
- Views: 2534
Warning Msg in wrapper stage job
Hi,
I am calling script from wrapper stage.I am getting warning "WrapperStageName,Status code = 0"
This warning apperars when my script runs successfully only.
But in logfile how can i eleminate this warning message.
Please advice me on this issue.
regards,
Hiten
I am calling script from wrapper stage.I am getting warning "WrapperStageName,Status code = 0"
This warning apperars when my script runs successfully only.
But in logfile how can i eleminate this warning message.
Please advice me on this issue.
regards,
Hiten
- Fri Sep 22, 2006 4:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Equivalent stage/Universe database
- Replies: 4
- Views: 1698
- Fri Sep 22, 2006 12:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Equivalent stage/Universe database
- Replies: 4
- Views: 1698
Equivalent stage/Universe database
We have universe database stage in server job so what is corresponding stage or any utility in PX ?
As i want to find out all job name in current project.
Please suggest me on this topic.
Regards,
Hiten
As i want to find out all job name in current project.
Please suggest me on this topic.
Regards,
Hiten
- Thu Sep 21, 2006 4:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Xml Transformer/XSLT stylesheet warning
- Replies: 0
- Views: 1528
Xml Transformer/XSLT stylesheet warning
I am reading data from xml file(Sequential File Stage). My job design is like : SeqFileStage --> XmlInputStage --> XmlTransformerStage. In xml transformer stage i am giving output file name. while running this job first i got warning message " XML_Transformer_13,0: Error: The transformation XSL...