DSXchange

Hi Please can any one help me with this. what is the order for restart ALL server: Following are the steps i am taking now is that right pls can any one tell me. What is the Sequence to Stop all Services? The stop commands must be executed in the following sequence: 1. Stop DataStage Engine 2. Stop ...

Hi Thanks for your replay i used the following steps to get the Indexs in my job In Job properties-->environmental variable--->Operator Specific---> APT_ORACLE_LOAD_OPTIONS(right now the Value box is empty) and set the values as (DIRECT=FALSE,PARALLEL=FALSE) But the job aborted and i got the followi...

Hi Please can any one help me in this issue i am importing the DS job from Staging to Test, i got all the job what i need from staging to Test and i try to run job in test enveronment. i took a small job i.e imported from Staging, but the job is aborted(this job run good in staging and i got the res...

Hi thanks for your replay, please can you tell me where i need to give the Environmental variable APT_ORACLE_LOAD_OPTIONS as (DIRECT=FALSE,PARALLEL=FALSE), do i need to go into adm--> properties-->environmental variable--->Operator Specific---> APT_ORACLE_LOAD_OPTIONS(right now the Value box is empt...

Hi I have a job that loads data into a table [Source(dataset)---->target(oracle stage)]. The data loads correctly into the table but the index becomes corrupt and has a status of 'Unusable'. I can correct this problem by manually rebuilding the indices through a sql client but shouldn't have to. The...

Hi Please can any one help me to understand what excilate the Agreement Weight(AW) and Disagreement Weight(DW) do and give me one example how does it works for following. 1)Agreement Weight (AW). An agreement weight if the values for the column agree and are not missing. Please give me one example h...

Hi Thanks for your reply, i tried constraint @OUTROWNUM <= 50000 to the output link in transformer stage but the result still show me the same output 236615 reocrds in target and second one - Run the job with the Stop stages after Limit tab option set to 50000 rows, Stop stages after limit tab was d...

Hi

Please can any one help me in this issue, input is a dataset which gets 236615 records and the target should be 50000 records and i am using a transformer stage with @INROWNUM to count the Input records, but what will be the next step to get the 50k records in target.

Thanks

Hi
Can anyone let me know how to get datastage complete detail log for a particular job in to a text file.

Thanks
Kiran

Hi

Please can you tell me where can i find the RTI Console in 7.x and give me some directions to find the RTi Console. so that i can stop the RTI jobs.

Thanks

Thanks CHULETT
Please can you tell me where can i find the RTI Console in 7.x and give me some directions to find the RTi Console. so that i can stop the RTI jobs.

Thanks

Hi

we designed the WISD job in DEV and the job is running 24/7. but is there any way to stop the WISD jobs i am running outof space in my database.

thanks

Hi

Thanks every one problem is solved and the file is loaded into target.

Solution: problem with file when its loaded into seq file

Thanks

Hi yes file is present when the job started running. we reset the sequence job when it aborted and restarted the job but it still giving the same error. Issue: seq file stage,0: Unable to open /export/local/dsadm/ProjectName/PRD/Aga/Input/xxx/FILENAME.dat: No such file or directory. [new-impexp/file...

HI Thanks for your reply, we can see the file using the cor FTP, its in the Datastage server and sequential file stage is used to read the file and sends to further validation process in the job, when we start running the job the file is not able to pick and the error is Issue: seq file stage,0: Una...