DSXchange

I tried to search with following key word but not able find any post. 1.Migration from windows to Unix. 2.DSX Migrations. 3.DSX Migration from Windows to unix. 4.DATA STAGE Job migration from windows to unix. 5.Project migration from Windows to unix 6.Project export from Windows to unix could you pl...

I am selecting date column from a table in OCI stage and putting into sequential file. but in sequential file dat is not showing in proper format.

I have tried with to_char for date column while selecting but it's not showing in proper format. can anyone please help me?

Thanks ray.wurlod,WoMaWil

could you please tell me where can i find SQL User Guide

Could you please let me know how to query on hash file?

Syntax of sql stmts for hashfiles

I have read one of the post(Posted by Ray) saying that transformer has no more performance issue after 7.1 edition.

Could anyone please explaing what are the changes that brought in transformer after 7.1 edition.

ray.wurlod wrote:You can get timeouts on the server itself, on the domain controller, and/or in the network, all caused by too great a load. ...

Thanks ray. could you please explain me domain controller

I am getting erroe TIMEOUT expired while logging into Datastage. This is happend never before and my credientals were not changed. after server reboot with the same credential i am able to login. what could be the reasons for this? due to load on server , server may not be able to authenticate my cr...

Thanks ray..

Suppose

If we are making a look up on a hased file A in a multiple jobs and all running parallel

Or
Do we have to run job which are making a look up on hashed file A in a sequential manner,

Which one of the abovve is best?

If i am having lookup on hashed file in multiple jons will performance impact badly?

Ofcourse if we do parallel activity the performance may reduce but question here will this impace severly?

hamzaqk wrote:Did you mean purge the last log before running the job again ?

actually I have requirement to purge the all logs from a projects since log files impacting on disk space.
mean to say purging log files of jobs involved in project at a single short

Is there anyways to delete all the logs of the jobs in a project at a time

While accessing my job datastage is displaying the job is already is been accessed by other user. but this job is opened by me before and datastage aborted abruptly. after my re -login i am unable to open my job. I tried to clean up resources from director. and tried to kill the process from unix te...

I have got error Abnormal termination of stage(Whicch is transformer) at Transformer while transferring data from Oracle stage to another transformer.

Request you to help

Hashed file is one in which the links go out from file.
and Hash file is one in which links come in