DSXchange

I have file in the below format ID Sev 1 Sev 2 Sev 3 ABC 0.45 1 1 PQR 0.45 1 2 XYZ 0.45 1 1 I want to change this to the new format as below ID Severity Values ABC Sev1 0.45 ABC Sev2 1 ABC Sev3 1 PQR Sev1 0.45 PQR Sev2 1 PQR Sev3 2 XYZ Sev1 0.45 XYZ Sev2 1 XYZ Sev3 1 To bring the column names as row...

I am on 8.5

So installation of IBM InfoSphere Information Server, Version 8.5 Fix Pack 2
would fix this issue ?

In one of the scenarios, I am writing the transformer output to a Sequential file which I am using to load in the another Database, in that case order does matter. In the case of stage variables, this one is a calculated one which derives its values from some of the following stage variables. So it ...

Hi, I am facing a strange issue. After restarting the Datastage services in the server, I found that the order in which I have arranged the column in DS Transformer seems to have changed. Note sure how many days the updates are getting backdated. One day before the services restart, I had changed th...

Hi,

I think its a simple one..

I have 2 files as listed below.

File1 File2 I need to create a file3 as below
Can somebody help

Not sure if this is a valid question..

When I connect to the XMETA database, I use the option "Use Implicit credentials", then it doesn't ask me user name and password.
Do we have a separate user name and password for logging in to XMETA ?

Sure craig.

I will take that point. It a valid one. Thanks for your inputs

-Sree

Thanks Ray. I just changed the format

Hi Team, I am trying to do a row wise comparison. Is there any way I can break the operation based on a condition ? I have the below rows Row | Dept | Hours 1 ABC 10 2 ABC 15 3 XYZ 10 4 ABC 15 5 ABC 20 I want to break the operation at row 3 where Dept Not equal to the following one. In this case ABC...

I have also specified a different directory other than my normal project directory (D:\IBM\InformationServer\Server\Projects\)
My D Drive has close to 200 GB Free space.

But still the same error. Can somebody help

I could see this post in this forum. http://www.dsxchange.com/viewtopic.php?p=430403 But I am already using the Websphere which comes along with V 8.5 and I was able to create projects earlier. Also when I checked the 'Active sessions' through Information Server web link, it shows the NO value for t...

Hi Team, I am getting the below error while creating a new project in Datastage. I had created 4 projects earlier and it was working fine. Not sure what changes caused this error. Error message: Errors were detected during project creation that may render project Test_Project unstable. Please contac...

Hi,

The issue got solved. I was mapping this user id with wrong OS account. I corrected it by verifying the same in Engine credentials as mentioned by Ray.

Thanks to Ray.wurlod and priyadarshikunal

I have verified that credentials are correct. I have doubt only about the 10th step. I could see some groups/users under the policy 'Allow logon Automatically'. But I am not sure whether my new id is part of any of this group. When I try to add the user id it says that id cannot be found. It could b...

Hi,

I have referred this link and mapped the engine credentials.

http://publib.boulder.ibm.com/infocente ... layer.html