DSXchange

anbu wrote:What is your source? File or Table?

Appreciate help on this from professionals

Are you switching between one and two terminal displays? Once I was brought in to diagnose a similar problem. The real issue was that the developer had switched from a two-display setup to a one-display setup. Some of his "pop-ups" had been moved to the 2nd screen, and as such, were no lo...

anbu wrote:What is your source? File or Table?

Source is a table

anbu wrote:What is your source?

Try this

Code: Select all

If isnull(col1) Or trim(col1) = '' then '' else col1

Nope this doesn't help.

Hi I have source decimal column as col1. 1st transformer: If isnull(col1) then '' else col1 When i see in the dataset after 1st transformer for the NULL values the col has all 0000000000000 In 2nd Transformer: If col= 1 Then 'Y' Else If col= 0 Then 'N' Else '' Source is a decimal column. Target is v...

ray.wurlod wrote:Have a DataStage Administrator check your DataStage roles. If you only have Operator or Super Operator role you will not be able to compile.

I was able to compile untill yesterday.My access shall not been changed.

Is there anything i need to look into.

Hi, 1) For some reason the compilation pop up is not coming and compilation is not happening on my system for all the DataStage jobs in all the datastage projects but team members are able to compile for the same server. I tried uninstalling and installing Datastage. That did not help me in any way....

we are planning to use oracle metadata repository for upgrade to 8.1.The IBM docs say we need to create the metadata repository manually before installing Information Server 8.1. We are using Oracle DB as our source and target and would like to use the same DB for metadata repository. Can we use our...

chulett wrote:All of which comes from the metadata repository... there really isn't anywhere else to 'export' from in DataStage. And the 'import' goes right back into the repository, regardless of what makes it up.

Thanks got it now

Not sure how many times you want an answer to this... and the answer hasn't changed from the other two times. :evil: Export from the old. Import into the new. I am relatively novice to the tool.When you say export does that mean export using datastage manager. If yes, i dont see the option metadata...

Currently we are using 7.5.2 planning to upgrade to 8.1. The current metadata repository is on Universe. we want to use oracle metadata repository now. 1)Would like to know detailed steps to move metadata from universe metadata repository to oracle metadata repository. 2)For 8.1 is xmeta ie RDMS rep...

The 8.x versions use both repositories, you have no choice in the matter, nor do you have to worry about transferring anything between the two as it will manage all that automagically during an upgrade or import. Thanks Chulett!! But i am not very clear with the answer.Are you saying 8.1 version us...

We are planning to upgrade from 7.5.2 to 8.1 and are trying to find: what is the difference in installation process when we are trying to 1) upgrade 7.5.2 to 8.1 (replace 7.5.2 with 8.1) 2) Install 8.1 in co-existence with existing 7.5.2 on the same server. My understanding is we need to provide Tag...

We are currently using Datastage 7.5.2 and planning to upgrade to 8.1, our metadata repository is currently on Unvierse DB. I have the following questions: 1) Can we use the same Universe metadata repository for Datastage 8.1, or we have to use oracle metadata repository as we have oracle DB. 2) Can...

Hi,

My Dsxchange ID: "highpoint"

I have made the payment on 06/18/2010 and have not been granted the premium privilleges yet.

I have sent email to webmaster, director and personal message to the editior as well.

Would appreciate if someone could help me on this.