Search found 25 matches
- Tue Jun 19, 2012 12:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Number of reference links limit
- Replies: 15
- Views: 10845
Re: Number of reference links limit
when there is data growth, adversely affect the execution speed. Lookup can have N+1 input links.
- Tue Jun 19, 2012 12:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SQL Procedure - Invalid Argument Value
- Replies: 2
- Views: 2360
Re: SQL Procedure - Invalid Argument Value
Can you check Stored proc input/output parameter count, parameter type(input/output) etc..
- Tue Jun 19, 2012 11:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Deleting datasets
- Replies: 4
- Views: 2541
Re: Deleting datasets
execute command from below directory will help
/etl/InformationServer/Server/PXEngine/bin/
/etl/InformationServer/Server/PXEngine/bin/
- Thu Jun 14, 2012 2:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Combining multiple column and record data into single output
- Replies: 1
- Views: 1375
Re: Combining multiple column and record data into single ou
Quick design, ---- remove dup (Col1)----- ---- remove dup (Col2)----- input ---> copy ---- remove dup (Col3)--- transformer- pivot ----> Output ---- remove dup (Col4)----- ---- remove dup (Col5)----- This may help, Pls improve the design.
- Thu Jun 14, 2012 2:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert String to Decimal
- Replies: 2
- Views: 2260
- Thu Jun 14, 2012 2:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert String to Decimal
- Replies: 2
- Views: 2260
- Thu Jun 14, 2012 1:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert String to Decimal
- Replies: 2
- Views: 2260
Re: Convert String to Decimal
This may help(Havn't tested it ),
StringToDecimal(Trim(Trim(<string>,"+","A"))),"0","B"))
StringToDecimal(Trim(Trim(<string>,"+","A"))),"0","B"))
- Thu Jun 14, 2012 1:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Access SAP R/3 using Datastage
- Replies: 7
- Views: 4167
Re: Access SAP R/3 usign Datastage
1. Maybe, But IBM is not providing support for Datastage 7.5 or older versions..
2. Yes, You can use any Datastage job which design to receive IDOc's
Thanks,
Bharath Tipirisetty
2. Yes, You can use any Datastage job which design to receive IDOc's
Thanks,
Bharath Tipirisetty
- Thu May 05, 2011 4:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance Tuning
- Replies: 4
- Views: 2570
- Wed Apr 27, 2011 12:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to take first 10 charectors from the input column
- Replies: 4
- Views: 3205
Re: How to take first 10 charectors from the input column
you can also use DSLink3.name[1,10]
- Wed Apr 27, 2011 12:02 am
- Forum: General
- Topic: Exporting DS jobs through CITRIX machine/DS Server
- Replies: 5
- Views: 5020
Re: Exporting DS jobs through CITRIX machine/DS Server
In CITRIX virtual machines are mapped under metaframe server, Usually datastage installed in virtual windows server 2003 machine. Login datastge manager, try to export DSX and check for directory which it is pointed to. My guess you can interface Dev windows & Dev unix in putty using FTP. You ca...
- Tue Apr 26, 2011 2:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Removing Duplicates : unique situation
- Replies: 13
- Views: 11284
- Tue Apr 26, 2011 12:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while Reading || Sequential File
- Replies: 7
- Views: 5178
Re: Error while Reading || Sequential File
Can you Check max length of that column/ Check any record contains extra delimiters.. like comma in full address column.. etc
- Mon Apr 25, 2011 7:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data file having header and taielr. Want to read the file wi
- Replies: 7
- Views: 6626
Re: Data file having header and taielr. Want to read the fil
have a unix script to just copy source file in before job sob routine, using SED or unix shell script help keep 1 & last line , remove rest. do all your calucations, in after job subroutine again create simple Copy script or ftp script to transfer files....
- Mon Apr 25, 2011 6:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Find the Rejected data from which source
- Replies: 1
- Views: 1186
Re: Find the Rejected data from which source
Introduce alias column like Source_table while selecting data from source, use the same as identifier in reject data.