DSXchange

You can only revoke the DataStage Administrator role in the Web Console for Information Server. Until you do so that user will have full access to anything in the project. And to do that you need to ... As you mentioned i have cross verify that it was Login:dsadm so this user contain super user cre...

Hi,

I am having a issue while loading data to the oracle database:

While loading 1lakh records job got aborted after loading 30K records.

Is it possible start loading from 30001 in the next run.
Please share Your ideas on the same

Thanks in advance

Not Super User. Super Operator. Open DataStage Administrator client, connected as a user credentialled as a DataStage administrator. On the Permissions tab, select that user, and allocate Super ... HI Ray. I have opened datastage admin and selected the project under permissions currently it is show...

ray.wurlod wrote:Use Super Operator role. ...

Thanks For Reply Could you please explain what i have to take action for that Super User and also please explain the process

Hi, I am facing problem while doing KT through Webex For OtherVendor the problem was they are able to View the datastage job and also they may change the code so now our plan to give only Restrict readonly access for Perticular Users for datastage jobs. Could you please suggest is there anyway to ov...

HI
Thanks for reply But Here what you suggested it may not correct for what i am expecting for exaple if i am having Source
Col1
00000000101.00
00000000055.12
00000000505.10

OutPutRequired:
101.00
55.12
505.10
Please give me any Ideas for the OutPut.
Thanks In Advance

Thanks For your Quick Reply But i tried all the ways For Example: Decimal to String(Col1,'Supress-Zero') This will remove all the Zeros from input But My requirement Like 000000023.20 here required output 23.20(Trailing Zero Required) If i use above function it will remove all the Zeros and alo I tr...

Could you please anybody explain how to remove the Zeros with Decimal datatype: I am having source Col with Datatype decimal[20,2] i am getting data for example 000000000000000038.50 but i want to make target like 38.50 means i want to remove only Leading Zeros not Trailing for this i tried to Cover...

Take things a step at a time. Make a job with just your MQ stage and a text output file or a PEEK stage. Does the XML (as a string) get correctly processed through the MQ stage and output? Once you have that working, add the XML input stage; if it no longer works you know you don't have a MQ proble...

If you don't specify either a number of messages or a wait interval then your job won't stop running; is this what you really want? Also, this is not a fatal message (I know, since our MQ job here give out this warning but that is because we want it that way) but just a warning. Thanks for you quic...

Hi , Could you please explain how to use mq connector as source. Means:I have QueueManager name ,Connection Name ,and queue name and also within that queue having xml message here my job desing is as follows: MqConnector------>XmlInput-------->Dataset Is this way for reading xml message from source ...

HI , while creating the xml output in stage dont give validate xml and give open and close tag and also make sure that aggreate allrows it will create

we want to know the out put how ur genarating like ur sending to mq or sequential file or any plugin's like sap.

Hello ,your post is not clear in this situavation if u dont have any rejects you need to use Join stage and also need two joins for solving the problem . TD_ADDR_ID TD_CUS_ID ----.>sort-------------->join---------->sort-------->Join----------> No Need to replace first join with one unique key column...

Hi.. I have developed a job with two sequential stage and exported the job as xml file.. Ihave used the this xml file as an input in the xml input stage... Here in this we have to specify a repition element on which the output xml wil be generated.... here i have a doubt on what basis you select th...

Hi , you need to use rowgenarator----------->Transformer--------->xmlinputstage--------->write datasets(how many you want outputs) If your xml chunks are repeting take it as a key coloum and write into separe datasets (For Every key you need to take separate dataset) Then only you are able to read t...