DSXchange

ok...so following on Craig's note, tell us more about "that" Job...what makes it unique? Ernie that job has source Dataset and has a copy stage goes to the lkp stage then other link from the copy goes to the transformer where we do some trnsformation goes to the XML and from that XML goes...

Hi, I am not able to connect the SQL Server through ODBC in my production environment where as i can connect the same in Development with same ID & Password................i can read the source data in development through ODBC but not in Production...i checked all the settings in .ODBC.ini file...

Can you get "any" XML to work? Yes,but the XML O/P stage fails for that particular job when i just use as o/p and read from that as well.But same job runs fine in 7.1 version when imported to 8.1 it fails. But when i use the same XML o/p stage just to write also fails with same error. Do ...

Sainath.Srinivasan wrote:This error is normally accompanied with another warning / error. Do you see any ?

I did not get any error on that XML stage rather am geting the usual warning of cannot preserve partitioning on the sort stage.

we are doing an upgrade in DS in which we have a job where source is a data set and we store that in a XML and get back from xml and that particluar stage shows up an error saying "Caught unknown exception from runLocally()".I have no clue how to approach this error.any help.

hi, 100,a,hyd 101,b,hyd 102,c,blore if i use remove duplicate o/p will be like this:100,a,hyd 102,c,blore but required o/p will be like this:102,c,blore can any one help....... Will the third column will be of same size.then u can use as key but when your coulmn comes like blore and banglore then y...

That i checked earlier with making it as nullable it was working .but why is the problem comes when i use NVL in the query to substitute, is with Datastage 8.x assuming the computed value as nullable irrespective of definition.My concern is we are doing upgrade with the DataStage as we have tons of ...

they are coming correctly but i feel i use a case statement in the select with that field, so will Datastage takes it as nullable by default even though the source has nonnullable and have a default value as Decimal(38,10) even though the source has integer which is int32.

I checked it is same.

ArndW,
Database metadata even with nullablity is identical with the Datastage. Is some thing to do with datastage versions.

The first one happens whenever we run the job but the in the second one there is no nulls in the specified field but it throws up an error.

Hi, We are upgrading from 7.1 to 8.1 we have encountred a problem on the oracle DB where there is user defined query in that which does some join etc going to a copy stage but it throws up an error saying waitForWriteSignal(): Premature EOF on node xxxxxxxxx Socket operation on non-socket but the qu...

Are you meaning to any MQ's then there is MQ stage available in Realtime category,that stage has the option of specifying you queue manager and the exact queue. you can visit Ernie blog

http://dsrealtime.wordpress.com/category/mq/

What is your requirement? you need to load the dimension and then the facts .Is your dimensions are from multiple target table of Informix? pls give us more detail on the DWH design.

Please post in the respective forum