DSXchange

Hello I am getting below error when I am trying to instal datastage 11.5 client on window 7 where already 9.1 version is existing. Local computer has admin access and 64 bit and I am installing 64 bit client version. any idea why I m still getting this error. Also local computer has updated Java ver...

It is specified to UTF-8 in teradata connector stage and also project default one is UTF-8. Still this warning is occuring.

If I specify Unicode its throwing below warning. Any thoughts ?

"Conversion from UTF-8 character set to UTF-16LE may affect performance."

Hi Guys, I'm getting the below warning when I'm trying to read the data from Teradata using Teradata Connector stage. Any idea on how to get rid of this warning? When checking operator: When binding output interface field "SRC_ID" to field "SRC_ID": Implicit conversion from sourc...

Unfortunately , I couldn't see your full message.But, the rule I ran did't create the table automatically. we can manage the tables but why it didn't create referred table automatically. Is it becase of permissions issue of the user I am using. ?

I created a sample data rule and ran in information analyzer . but when I try to view the output, there is nothing except below message. if we need to create output table where to create ? In my requirement I dont need output table. I just need the results into a report. Also the rule was not "...

Yes. We assigned the datastore to IA project and its working fine.

We created an information analyzer project and imported the metadata. now I want to do column analysis on a table. so I clicked on INVESTIGATE -> ColumnAnalysis -> but I found nothing on the Column analysis workspace. It is just empty and tasks pane is completely disabled. I am not sure why ? Please...

Thanks for your reply. Sorry I did not find similar post in my search. If I remove the "Generate Formatted Output" check box, entire record is displaying in single line. <claims><claim><casetype>U</casetype><casedate>2012-12-13 17:55:25</casedate><esn>1000000020</esn><newesn>1000000020</ne...

Hello I am trying to generate xml file using using xml output stage. The xml file is getting created but the format of is not as expected. Please suggest if anybody come across this before. Design: oracle connector -> transformer stage -> xml output stage. Getting output as below: <claim> <casetype>...

I m not able to write multiple unix command in External stage. But
when I give sftp userid@remote.server is working.

Is it possbile to write ls -ltr result into an output. ??

Guys I have a datastage job to read a file(sales_20121112_0910.txt) from sftp remote server. I am using path/sales* in ftp stage(parallel job) and able to read data. But I need get exact file name to load into a table. also I need to move the same file to another folder in remote sever. since I am n...

Resolved with "Open command" option in SFTP stage

I m able to connect to remote server.
but not able to rename the file.

error:
Reply=127
Output from command ====>
SH: rename: 0403-006 Execute permission denied.

But I its working thru patty.

Does the sftp stage supports to rename the file ???

Guys I need to connect to remote server using Sftp and rename a file. I used below command in executive command activity stage. but not working. If I execute below commands separately in putty its working fine. Any thoughts on why it is not working ? or is there any other way of doing ? I can only d...