DSXchange

Think tanks - Do we know the solution to this yet ?

Like what stages needs to be used and what needs to be input to each stage and expected output.

Thanks.

Hi , Im working on Datastage Server jobs ver 5 which is on unix server ,i have a database which is on windows. when i put data from file to the target DB on windows which is oracle im getting "TNS: could not reolve the service name. I can however login onto the Database using PL/SQL developer t...

Hi, Please have the details to analyze further , I cant use a Hashfile bcoz of following reason , 1. I have a source selecting a column A 2. I have to do a lookup which is having source query like this , " select T1.A1 from table T T1 ,T T2" where <join conditions> --- note this is a self ...

Hi All ,

Thanks alot for the suggestion.

The reason iam not using hashfile is
1) the lookups are not taking time .
2)the source (stream link) is taking a long time.

Somehow need to improve the source OCI rather then for lookups.

Will make all lookups into hashfile and check again.

Hi All, Iam using 5 oci stages with complex queries which are tuned at the maximum that can be done. The queries take less time when it fired on database(SQL prompt). When the job is run it takes a 1 rows/sec or even 0 rows/sec.One OCI is the stream and rest all are look ups(please dont suggest on m...

Hi All , Thanks for the suggestion its was a great help from you all.

Hi , I tried the CLEAR.FILE <Filename> but its giving error "Unable to clear Filename . Filename = " I even tried with the complete path where the file is stored its giving me the same error. eg.I issued this command. CLEAR.FILE \imsv14\SAILDEV\hashfiles\Hash_BEngTaxonomyTermGroupKey

Hi , I tried the CLEAR.FILE <Filename> but its giving error "Unable to clear Filename . Filename = " I even tried with the complete path where the file is stored its giving me the same error. eg.I issued this command. CLEAR.FILE \imsv14\SAILDEV\hashfiles\Hash_BEngTaxonomyTermGroupKey

Hi , Thanks for the reply but iam getting an error message when i try to execute this command saying "Verb CLEARFILE is not in your VOC",can you suggest on this .

Also let me know where can i search for this commands.

What is the command that i can use to clear the contents of a Hashfile in DataStage Administrator Command Line Interface.

Note: I already know how to clear the contents of the file using the Clear file check box option in the job.