DSXchange

Hi, I'm trying to export the table definition for individual component in the excel/csv format. Is there is any way to do this as I was unable to find any options in export utility. Rgds, Hi, Do you mean to say, you do not see that particular table definition in the "table definition list"...

Export NullToZero Transform from another project, selecting the "include read-only objects" option. You will then be able to import it into the project from which it has been deleted. It will still be read-only. Thanks a lot, Ray. Sorry for replying late. Well that day, when I attempted t...

Hi,

I checked the manager. The "nulltozero" should be in the "Transforms" folder but in my current project, it's empty. I don't know how it got deleted!

I am not able to import the inbuilt transforms from other project. (read only).

Any other way?

TIA

I am getting a goofy error while compiling the jobs. In Transformer Stage, all the column transformations where I am using "nulltozero", have become "Red". I checked out other jobs and it's the same. The jobs which were running fine till now, are suddenly not even compiling becau...

Hi, I am using MSOLEDB stage to load into the SQL Server database. In OCI Stage, we select transaction size as "0" if we want to committ at the end. But what should I do for MSOLEDB Stage? It does not accept "0" value for transaction size and array size. It accepts values between...

ray.wurlod wrote:Fire up the Hashed File Calculator on your DataStage CD. It's in the Utilities\Unsupported folder. Play and learn!

Thanks Ray. I will do that. And may be again get back to you if I have any concern.

I need to ask the client side people for the Datastage CD.

Upper limits for 64bits is high terabytes. Limit for 32 bit hash file is 2.2 gigabytes. DS only creates 32bit hash files thru the Designer, you have to use command line create statement to get a 64bit file. Hi Ken, I had no idea we can do this. I thought because Datastage is a 32 bit environment, t...

Yes, offcourse you can have different metadata for each file you are writing to even though you are using one sequential stage. It's exactly same as we write to a database with multiple links. You need to select the proper input name in the drop down list and load the corresponding metadata. About t...

Thank you very much for all your suggestion. I know I have tried all my options. Thought of solving this issue today but need to catch my flight now. We will reboot the DS server next week when we are in and let you guys know. Ken, yesterday, I was able to tnsping yesterday. I will let you know. Tha...

Thanks. Oracle is installed in the same directory as it was earlier.

Yes kenneth. We did that. Thinking of installing windows again. And then, oracle? But before that want to check out some other solution.

Hello, We moved our current project to another etl box and now I am getting the following error (oci) when I try to run a job: ds_loadlibrary: Win32 error in LoadLibrary of oraoci9.dll - The specified module could not be found . I re-installed Oracle9i in the server but I still get the same error. F...

DeepakCorning wrote:I want to confirm from you guys , Is it possible to do full outer joins and UNIONS in DS without any problem? And I think the only way to do is to use User defined SQL right??

Yes. I have done that in User Defined SQL with out any problem.

You are wrong. How can a NUll be equal to a Null? A Null is never equal to Null. It's not an integer where you can perform mathematical calculation or comparision. Use what Ambuj said, "IsNull(column_name) Then .. Else column_name" or you can use, " if nulltozero(column_name) = 0 then...

Its checked their but still i can not see the jobs in the repository but jobs are their coz i can open the recent opened jobs in the file menu. Hi, This sounds interesting! As far as I know, in Administrator there is no option to block the view of jobs. Sorry but I can't think of any other reason. ...