DSXchange

ray,


I did the usage analysis from the Datastage Manager for the xyz table definition and found no dependencies...


I am not able to go-ahead with the import of my jobs in metastage.

any suggestions??

Thanks in advance,

ray, Yes . It expects the table definition under saved category to be present. However table definitions are also there, which i have exported with the correct source and target table names and not with some xyz which i saved in due course of dev. But, what is surprising is that..... it is searching...

Hi all, I am new to metastage .Please help me with the scenario I have. 1.I have a simple Job designed(source ->target) using ascential 7.5 . I also have all the table definitions stored under TableDefinitions\Saved\ 2. Along with this while designing the job, to ease dev I had saved the columns in ...

Hi,

we also encountered this error. As arndw has said, it is due to incorrect setting of the variables.

Set array size equal to 1 and also check for the unique constraint violation .

Hope this helps

lax

chulett wrote:

via wrote:Is there some thing i am missing to do for importing the Environment variables while doing whole project import?

Yes

copy the DSParam file from your Old project and place it in the new project .

lax

I have created a new project in the production environment and when trying to import my jobs into that project , i get the following er ror: "Failed to connect to host: host_name , Project: Project_Name . The directory you r connecting to either is not a UV account or does not exist. Internal e...

You can check show all tab <director---view--show all> .This shows all the log entries. Allows you to see the last entries as well as see where exactly the job is causing the error.

This is the problem Of EXACTNUMERICS.


See the prev post for more information

http://dsxchange.com/viewtopic.php?t=91108

Hi, This is a smple job with two transformation stages. the first transformer stage eliminates all the empty spaces using "StringSpaces" . The second transformer has three hash file lookups performed. The schema looks something like this: Source---->Transf Stage---------> Transf stage-----...

Hi All, I have to run a job on ascential datastage with around an estimate of 600000 rows of data. The job terminates with warning" Abnormal termination of the job at the stage XXX" However, when i run this job with giving the "limit " <say limit of 350000> it runs with no issues...

Hi Chulett we perform this conversion from 23 to 19(timestamp). This is because we supress the millisec part in the datefield . If not done, the lookup might fail, even though the date and the time of the source is matching with that of the lookup. Eg: normally we have the datefield as: 2004-11-11- ...

Hi All,


I have to change the Timestamp of length 23 to 19 in the Hash file for about a set of 500 Jobs. What could be the best practice to do this. Can we write some query to reduce the time spent to do this work .
Please let me know , if anyone can answer this question.

Thanks in Advance,
lax