DSXchange

Ray..thanks a lot...
Your reply saved my day

I have a comma delimited flat file as source with two columns The first column is timestamp in the format 2013-02-27 00:00:00.000 The second column is a varchar So data looks like 2013-02-27 00:00:00.000,abc 2013-02-28 00:00:00.000,def and so on.. Note that the timestamp has microseconds specified w...

I managed to to get it right by re-installing with a new operating system user..The only change I did was that the last time I was logged on to the LAN and was on the Intranet domain. This time around I did the installation with a new operating system user which was local to the system on which I wa...

Any suggestions here?

Sorry to say that I am not a premium member.
Although it is a new installation, I expected to see the Engine host name when I go to Engine Credentials. I am not able to see this.
The error is No Data Found

I have done a fresh installation of InfoSphere DataStage 8.5 on my Windows 7 machine with all the tiers on the same machine. The installation was successful and I could login to WebSphere Console. But in the domain management > Engine Credentials, I could not find any entries. It just shows Data not...

So this means I have to rely on database functions and not on DataStage?

The source as well as target will be database

I have a requirement to Convert Amount in integer to amount in words
For eg: 1500 in source should get converted to Thousand Five Hundred in target

Any suggestions?

Any suggestions...any one?

We haveDataStage 8.5 on AIX 6.1 We have notification activity set up for a couple of critical ETL The sequence gets executed successfully, but we receive no mails I did a quick search on this forum and found that most of the time it is issue with the AIX, but in my case i found that I can send mails...

I installed DB2 client v9.7 on the engine machine and now able to use DB2 connector stage. However when I do a view data it says cannot load library. However job runs successfully. I have added the required entries in the dsenv file and also set LIBPATH

I am using ODBC connector stages in my job. The job has source,transformer and target. Source ODBC connector has db2 database and target is SQL Server There are 10 columns in the source which is of data type Decimal(8,0). These contain dates in yyyymmdd format In the target these columns are of date...

The issue went away when port 9107 was opened from client. Interestingly enough, this port number does not find a mention in the Installation document. We came to know of this by co-ordinating with the n/w team and they informed us that when the client tries to connect it tries thru this particular ...

I rebooted the WAS/Metadata Repository(both of which were on a separate machine together as we have a dedicated engine topology) and the issue went away.
Might be case of services not running previously which caused this.