Search found 887 matches

by Sreenivasulu
Thu Nov 04, 2004 5:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with DataStage Server installation
Replies: 8
Views: 4043

Configure the C++ compiler

Parallel Extender uses C++ compiler for compilation. You have to
configure the C++ comiplier with Datastage using Datastage Administrator.

Hope this helps

Regards
Sreenivasulu
by Sreenivasulu
Wed Oct 27, 2004 5:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Differences b/b PX 7.1 and PX 6.0
Replies: 2
Views: 1767

Re: Differences b/b PX 7.1 and PX 6.0

Hi Nitin, Please find the diff between 6 and 7 1.Cannot do Cut/Copy of stages in 6. 2.If the size of numeric data is more than 10 digits then jobs were aborting in 6. Not present in 7. Regards Sreenivasulu Hi, What are differences in functionalties/ features b/n PX 7.1 and PX 6.0? Is there any diffe...
by Sreenivasulu
Thu Aug 05, 2004 2:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parsing Problem
Replies: 0
Views: 1263

Parsing Problem

Hi ALL, Requirement:Need to parse a string seperated by "_" Problem: The parsing works fine if we directly assign the logic to the column name but does NOT work when we assign the logic to a stage variable. The stage variable is not getting refreshed for each row of data. It is holding the...
by Sreenivasulu
Thu Aug 05, 2004 2:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Stage
Replies: 2
Views: 2712

API Stage is faster

Hi Maharaj

I heard that the API Stage is faster since it used native plug-ins.
We are using API Stage in our project

Regards
Sreenivasulu
by Sreenivasulu
Wed Jun 30, 2004 1:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Specify columns in Pivot Stage
Replies: 3
Views: 2729

Hi Girish,

Your suggestion really helped. Thanks a lot.

Regards
Sreenivasulu
by Sreenivasulu
Wed Jun 30, 2004 12:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with folder stage?
Replies: 14
Views: 6255

Hi Ray,

Sometimes what happens is the at the file name would have been
appended with control characters which is not visible from the
telnet window. Hence my suggestion was to rename the file
freshly.

Regards
Srini
by Sreenivasulu
Wed Jun 30, 2004 12:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Specify columns in Pivot Stage
Replies: 3
Views: 2729

Specify columns in Pivot Stage

Hi ALL,

How to specify two input columns ( syntax) in the "derivation" tab of a pivot stage. I could not find this in the documentation of datastage.

Regards
Srini
by Sreenivasulu
Tue Jun 29, 2004 10:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with folder stage?
Replies: 14
Views: 6255

Check the file name whether it correctly has ".DAT" in its name.
Rename this file with some other name having a .DAT extension and try.

Hope this works

Regards
Sreenivasulu
by Sreenivasulu
Tue Jun 29, 2004 4:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: User/pass
Replies: 5
Views: 3033

Create a new user using the "Domain Manager" and give adminstrative
rights to this user.

Regards
Srini
by Sreenivasulu
Wed Jun 23, 2004 5:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: One row missing
Replies: 7
Views: 3854

Uncheck "first line as column names"

Regards
by Sreenivasulu
Wed Jun 23, 2004 5:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Handling NULLs in fixed-width column sequential file
Replies: 6
Views: 3408

Ravindar,

Use the EREPLACE function. With this you can replace * will "null"

Regards
by Sreenivasulu
Wed Jun 16, 2004 2:50 am
Forum:
Topic: Installation of Metabroker,Quality Stage
Replies: 1
Views: 1437

Installation of Metabroker,Quality Stage

Hi All,

We have got CDs for MetaBroker, Quality Stage from our client.

But we do not have any clue of how to install this on the Datastage Server. Can anyone give us the fastest route

Regards
by Sreenivasulu
Wed Jun 16, 2004 2:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: lookup
Replies: 5
Views: 2532

The best visible advantage of Datastage over Informatica is that in Informatica there is no facility for hash lookup.

Hash Lookup as we all know increases the job performance by 10-1000 times depending on the data.

Regards
by Sreenivasulu
Mon Jun 14, 2004 11:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Delete rows in table Oracle
Replies: 9
Views: 2499

Using a delete would leave empty blocks (holes)in the disk space.
Therefore always use the truncate facility

Regards
by Sreenivasulu
Mon Jun 14, 2004 10:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: save as TimeStamp
Replies: 4
Views: 1627

I have a very good solution on this: We had a requirement of creating a file with a timestamp. 1.Store the timestamp value in a table. 2.Write a job which would hold this timestamp value 3.This job would call a routine which would call a second job 4.The second job would take this value as "Job...