Search found 25 matches

by Govindarajan
Thu May 12, 2011 3:01 pm
Forum: General
Topic: DS Client Error
Replies: 7
Views: 9727

Re: DS Client Error

I got this error recently, but the same has been fixed after reinstalling .NET Framework.

http://www.microsoft.com/downloads/en/d ... laylang=en
by Govindarajan
Thu Mar 04, 2010 8:04 am
Forum:
Topic: How to migrate Informatica to Datastgae
Replies: 9
Views: 4339

Informatica to Datastage

There is a tool available to convert informatica mappings into Datastage Jobs ......if you need any further info please send a mail to govindachari@yahoo.com
by Govindarajan
Tue Nov 18, 2008 9:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Server to PX Conversion/Migration
Replies: 4
Views: 1991

Server to PX Conversion/Migration

Is there any procedural way of converting all Server Jobs from 7.5.2 version to 8.0.1 version of PX, instead of re-creating equivalent PX jobs by manually?
by Govindarajan
Wed Jul 02, 2008 4:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deleting 25 rows in Oracle
Replies: 5
Views: 1712

Re: Deleting 25 rows in Oracle

How do you define this first 25 rows? based on any key column or date and time of record creation?
by Govindarajan
Wed Jul 02, 2008 4:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Age calculation from Date Of Birth
Replies: 6
Views: 2756

Re: Age calculation from Date Of Birth

Use TAG.TO.YEAR for date of birth and current date and subtract these values will get you the Age of the customer.
by Govindarajan
Fri Jun 27, 2008 4:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Query taking much time...
Replies: 5
Views: 3203

Re: Query taking much time...

In Toad, the system does not wait for fetching all rows. It bring only few rows to the answer window and while scrolling down the remaining rows are fetched. If you have millions of rows you may get the resultset with in seconds or few minutes, but it doesn't mean that all rows are fetched. So check...
by Govindarajan
Thu Jun 05, 2008 12:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: source system upgrade ( impact analysis )
Replies: 10
Views: 4526

Re: source system upgrade ( impact analysis )

Generate HTML report from your project (7.5.1 onwards) and search for the VIEW Name. You will be hitting the job name here and it would help you do the impact analysis.
by Govindarajan
Wed May 21, 2008 6:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to change the value for the $APT_config_file
Replies: 3
Views: 1883

In environment variable please pass the value against APT_CONFIG_FILE.
by Govindarajan
Tue Feb 26, 2008 5:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row Counts
Replies: 6
Views: 2433

You may need to run this program from bin directory. The bin directory location may differ based on the server. e.g /opt/Ascential/DataStage/DSEngine/bin
by Govindarajan
Thu Feb 14, 2008 11:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loop Activity
Replies: 1
Views: 1085

Loop Activity

Can anybody suggest a method for below question!!!! Source Data (today's load): ItemCode TotalQty 01 (1000) - negative value My target is (existing Data) ItemCode Sequence Qty Net 01 1 100 100 01 2 300 400 01 3 450 850 01 4 500 1350 01 5 150 1500 My Target should be updated like this ItemCode Sequen...
by Govindarajan
Tue Dec 04, 2007 11:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Node pools
Replies: 6
Views: 2341

job level parameter add the environment variable APT_CONFIG_FILE and change the default file name with the new file created by you under /opt/Ascential/DataStage/Configurations directory
by Govindarajan
Tue Dec 04, 2007 3:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Remove Header and Trailor records from a fixed width file
Replies: 4
Views: 2260

Re: Remove Header and Trailor records from a fixed width fil

If you do not have a clue about the header or footer follow the process:- a) write a shell script to get the number of lines (use wc -l <filename>) and store this value in a text file b) call this shell script from before job routine c) in your constraint do not process the following conditions eith...