DSXchange

HI Iam trying to import ODBC table definitions for two tables. It says authorization restricted. When i asked my DBA he said I have all rights for those 2 tables. He asked me "it looks it was trying to access and write using a system file...." I have no clue to this questions. The table de...

By designing a DS job to load data into Oracle and this job can be called at some specific event so that the input data can be loaded into Target DB. But you need to find a way to extract the changes from the source DB and loads the changed data into a file and this file would be the input. Pooling...

Hi May i know the total number of columns you are loading. As we know hash can accomodate 2GB. Calculate the total amount of data you will be loading into hash by adding up all the column lenghts. You will get a figure. If it is more than 2Gb then you have a problem with hash. You have to preload in...

Hi My requirement is there are two databases. One is DB2 and other oracle. When ever there is a new record getting into Db2 database I want my datastage to select those new records and load into oracle database into a specified location. Records keep adding may be in 1 min or 1 hour or 1 day. Thats ...

Hi
I want to rename the Job category.
Is there any way to do that. If I cannot Y is that feature not enabled in Datastage.
Thanks
Bye

Hi
New version of datastage 7.5.1 has plug in for Misrosoft OLE database and Microsoft SQl server Load.

I get the following error. Iam not sure whats happening. If I run all the indivudual jobs they are running perfectly fine. I have declared in sequencer all the parameters as environment variables. I checked all the parameters and they are fine. so Y do i get that error Attempting to Cleanup after AB...

I cannot see import scripts in my repository window nor in tables menu. Can anyone suggest what to do.
Thanks
bye

i got it done. The oracle was corrupted. I re installed it.
Thanks

hi
iam gettin the following error in oci.

ds_loadlibrary: Win32 error in LoadLibrary of oraoci9.dll - The specified module could not be found.

Can anyone help me out of it
thanks

I installed it on windows Nt machine. I did not find any problems so far. My version is 7.0.1.

You get it from ascential website.
http://www.ascential.com/eservice/produ ... ability.do

I guess the problem is with firewall. This happened to me too. When i disable the firewall i got it started.

HI
can anybody suggest the hardware requirements for a profile stage. The work load for my application will be around 3 million files. Iam completely new to profile stage. Infact i dunno anything about it. so can anyone tell me the hardware that can be used for it
thanks

HI
As we all know IBM has fully taken Ascential datastage. Previously Datastage is more inclined to Oracle as it has various oracle stages. Now will newer version impact the oracle usage. The reason Y i ask is I know only oracle but dont have any idea about DB2.
Thanks