DSXchange

pkll

Hi,

I have input like:

sno,sname
1,ravi
1,suresh
2,mahesh
3,hari

but I want output like:

sno,sname
1,hari
1,mahesh
2,suresh
3,ravi

my source and target both are text files.I want to reverse second column (sname)

please any one help me?

pkll

Hi,

Code: Select all

Oracle_Connector_13,0: Memory allocation failed for 160,000,000 bytes. (CC_OraRecordDataSetConsumer::allocateBindBuffers, file CC_OraRecordDataSetConsumer.cpp, line 1,292)

I am getting above error ...let me know reason?

pkll

Hi, After completing a Datastage 9.1 installation I am getting below error. The operation failed because the database manager failed to access either the database manager configuration file or the database configuration file I have tried to open Web console for IBM InfoSphere Information Server, but...

pkll

Hi Ray, I have written query in oracle connector SELECT SUBSCRIBER_ID,RECHARGE_DATE_TIME,SERIAL_NUMBER FROM Recharge_Details ORDER BY RECHARGE_DATE_TIME; After that i have taken remove duplicate stage .In Removeduplicate stage key = SUBSCRIBER_ID Duplicate to Retain = First. Can you suggest me above...

pkll

I have two tables Recharge_Details SUBSCRIBER_ID,RECHARGE_DATE_TIME,SERIAL_NUMBER. First_Rechrge SUBSCRIBER_ID,RECHARGE_DATE_TIME,SERIAL_NUMBER. Compare the Recharge_Details SUBSCRIBER_ID with first_recharge table SUBSCRIBER_ID (at initial level First_Recharge table is blank) , if SUBSCRIBER_ID alre...

pkll

Hi All, I have custno,custname,loc columns are there in Customer table.In this i need to check custno is new value or not? if the custno is new value then insert the custno into another table,if the tcustno is already existed value then ignore the custno.... Can you please let me know how to find ne...

pkll

Hi Ray,

Thanks for ur reply I am unable to read ur entire sentence.
Could you plz explain ?

pkll

Yes I am getting below warnings and errors.. Oracle_Connector_21,0: The OCI function OCIStmtExecute returned status 1. Error code: 1, Error message: ORA-00001: unique constraint (SCOTT.SYS_C005447) violated. Oracle_Connector_21,0: The OCI function OCIStmtExecute returned status -1. Error code: 24,38...

pkll

Hi All, I am getting below Warning in Transformer. Transformer_3,1: Conversion error calling conversion routine timestamp_from_string data may have been lost I have not apply any Converions and i have not make any transaction on timestamp column.Just i drag and drop the timestamp coumn. Let me know ...

pkll

Hi Ray,

I am unable to read your entire sentence....

pkll

Hi All,

Code: Select all

Fatal Error: Unable to allocate communication resources

I am getting above Error.

Let me know why this error is comming?

pkll

Code: Select all

col3---->col1:col2(concatenate col1 and col2)

pkll

Hi,

Code: Select all

Once my job is complete move that file already processed to some other directory as archive .

Please let me know how to move file into archive directoryr?

pkll

Thanks chulett...

It is working 5n...

pkll

Hi Ray,

My delimeter is '|'. I specified field delimeter as '|' in sequential file format tab.

I am getting same error...

DSXchange

Search found 73 matches

How to reverse data order?

Datastage error?

Datastage Installation Error

How to find First recharge?

Find the new value or existing value?

Warning in Transformer Stage?

Unable to allocate communication resources?

Re: Generic stage - usage of "transform" operator

How to move file into Archive Directory?