DSXchange

Hi, I'm using DS7.5.3. I'm looking for the command and syntax to gather the MLOAD reject records directly to a file in Teradata MLOAD stage. I know it is possible but not sure of the command and its usage. Also pls let me know in which tab of the stage do I use it and how do I specify(syntax) it. Th...

Hi,

We are planning for a migration from AIX Unix to HP Unix. Does DS 7.5 support HP Unix? Any extra care has to be taken for this?

Thanks,
Karthik.

Hi, We had a dataset corruption issue during our run and we deleted the dataset using orchadmin command and recreated it. So far so good. But as a preventive maintenence, we wanted to analyse why the dataset got corrupted. When I search for the dataset inthe datasets folder, i find that there are 2 ...

Hi, I have a windows command script(.bat) file. I am trying to run a job through this script. When I ran it in DEV box everything was going fine, but when I have tried the same after exporting it to PROD I get a error that "ERROR Failed to open job, Status code = -1004". I have checked the...

Hi, Although tons of topics have already been dealt here,I couldn't find one which best fits my scenario.Hence listing out here, My datastage runs in windows, tool version - 7.0. I have numerous jobs in which the password and userid are hardcoded.I need to pass this as parameter such that I will be ...

Hi, I have a sequence which calls three parallel jobs. When I run the job seperately, it is finishing successfully. But when I run the sequence , it is aborting giving the following error message. " Seq name..JobControl (@Job Name): Controller problem: Error calling DSRunJob(Job Name), code=-14...

If you are using local naming (TNSNAMES.ORA file): - Make sure that "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA) - Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible. - Check that...

Yeah..sort of...
We are doing SCD changes in our jobs.
But does that means that we have to use generic jobs? Cant it be done using Normal jobs?
Also , u didnt answer for the 2nd part of my question.

You people are much more friendlier than my manager....

Hi, I have recently joined a new project. As per our Design, all our jobs are generic jobs. What does exactly generic jobs mean by? How are they different from normal DS jobs? We are using parallel jobs. Also our input is the sequential file and we are specifying the schema file instead of loading t...

Hi,

There is an option available in director to get the log in a file. Try it out if that would help you.

Thanks for your info. But your hint doesn't answers my question!

Hi,
I know that jobs are stored in the repository.But where does this repository physically lies?How can I find the created job in the physical path?

Thanks
Karthik.

I have an XML file, <Customer> <Customer_ad1> <Customer_com/> <Customer_ad2> <Customer_com> . . . </Customer_com> </Customer_ad2> <Customer> From this file i need to have both the customer_ad1 & customer_ad2 in my target file(Both are subtags of customer and are maxoccur = unbounded, but I am ge...

Where you want to kill a job is important. Let us know where you want to kill and why you want to kill Let's say that I have opened a Job and I have closed it, even after closing it sometimes i see that the Job is shown as still open with my ID. I which case I know we can give logout through direct...