Search found 10 matches

by ashyaal
Fri Sep 18, 2009 4:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To generate oracle sequence in Datastage
Replies: 2
Views: 2436

If there is any solution please let me know
Thanks
Ashish
by ashyaal
Fri Sep 18, 2009 4:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To generate oracle sequence in Datastage
Replies: 2
Views: 2436

To generate oracle sequence in Datastage

Hi I will like to generate oracle sequence in Datastage using any stage .It should incorporate the features like start value , incremental value , etc. Is this possible in Datastage . Basicaly my requirement is a squencer in any DS stage. If I used this in stage variable in Transformer stage then ca...
by ashyaal
Wed Sep 16, 2009 2:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: No connectivity to DS client. No o/p in dsproject -lprojects
Replies: 5
Views: 4029

HI
I have viewed the dsrpcd status post but my server is on windows and not on unix ,so what commannds should be used in that case.
Thanks
Ashish
by ashyaal
Wed Sep 16, 2009 2:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: No connectivity to DS client. No o/p in dsproject -lprojects
Replies: 5
Views: 4029

Can you please specify the steps to be acomplished for this or the place where i can find the steps to do the process of bringing ds down.
Thanks
Ashish
by ashyaal
Wed Sep 16, 2009 2:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: No connectivity to DS client. No o/p in dsproject -lprojects
Replies: 5
Views: 4029

user authentication failed

Hi I am facing the same issue .Can any please tell the root cause of this and any solution for it.The client was working fine but after some time when i tried to delete a stage it didnt allowed it .After that i closed and tried to login the same error message was populated .Can anyone help. Thanks A...
by ashyaal
Mon Sep 07, 2009 1:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Xml Import Error
Replies: 3
Views: 2166

Resolved

Hi
I have resolved it .Actually when i exported the file I was selecting output property values as externalised strings. instead of this output internal property values is used then only it can be imported.

Thanks
Ashish Goyal
by ashyaal
Mon Sep 07, 2009 1:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Xml Import Error
Replies: 3
Views: 2166

Xml Import Error

Hi I am using Datastage on Windows .I have made a job and then i exported that job in xml format. Then I imported the same job in xml format and it throws the following eror. Can ayoone help me. A valid datastage export file is expected to be in Windows format(ie using CRLF line terminators). Thanks...
by ashyaal
Thu Sep 03, 2009 5:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stage equivalent to Rank Transformation in Informatica
Replies: 2
Views: 2440

Stage equivalent to Rank Transformation in Informatica

Hi
Just like there is a rank transformation in Informatica where you can get reocrds with ranks .
Is there any stage in Datastage where i Can get the rank directly in a particular group.

Thanks
Ashish
by ashyaal
Fri May 15, 2009 3:09 am
Forum: General
Topic: Datastage warning (floating point decimal is not supported)
Replies: 5
Views: 8947

floating point decimal is not supported

Hi I have tried to use cast function but the issue is not resolving .In my souce oracle stage I have written the same thing 4 times in different ways but still the warning is thrown: 1) (select cast (max (ara.TRACK_NO) as INTEGER ) from ac_receivable_activity ara) as MAX_TRACK_NO 2) (select cast (ma...
by ashyaal
Thu May 14, 2009 9:05 am
Forum: General
Topic: Datastage warning (floating point decimal is not supported)
Replies: 5
Views: 8947

Datastage warning (floating point decimal is not supported)

Hi My field in oracle database is of integer data type. In my job on importing this field it display the data type as decimal 38. When I am running the job it gives a warning mentioned below on source. AC_RECEIVABLE_ACT_src_Ora: Column MAX_TRACK_NO floating point decimal is not fully supported; adju...