DSXchange

My design is : External Source Stage --> Read XML Stage --> Transformer --> Sequential File

I am reading the ETL Job Statistics from an XML File and loading a sequential file. But when I run my job I am getting the following error: main_program: Could not locate operator definition, wrapper, or Unix command for ", quote=none} ( AuditJobID:int32 {quote=none}; Name:string[max=255]; Desc...

Hello, I have a scenario where I want the maximum date from each partition.And from the set of rows I get, I have to get the maximum of that date and write it to a dataset. For example, If I have 4 partitions I will get 4 max dates, then I will sort these set of 4 dates and get the maximum out of th...

I included a "Partition Table" option in my oracle stage and gave my source table name as the partition table name, and I can see the performance statistics now. Both the issues have nothing in common and they are independent yet including this option enabled the performance statistics.

This is happening only when I introduce an ODBC stage in my job. If I work with sequential files, I am able to see the job statistics.I have to generate a xml file (DSJobReport) for every job and will need the no. of rows processed through each link. Right now I am getting 0 rows processed for each ...

I have checked the "Show Performance Statistics" in the job diagram but still can't see the job statistics.

After I executed sh jobmoninit command I tried running one of my simple jobs which just reads from a sequential file and writes to another sequential file, the job showed me the statistics. But when I used an Oracle stage, I did'nt see the statistics again. If i read from a sequential file or any ot...

here is a suggestion: Use a sort stage..sort on EmpNo and make the clusterKeyChange value "True". Then put a constraint on your transformer where all records having clusterKeyChangeValue 1 should go in one dataset and the other to the other dataset. You will get 2 datasets..one with all un...

just to clarify 20 lakh is 2 million records

I am doing an inner join between two oracle tables having around 20 lakh records. Actually one of the sources have about 90 million records but I have used a User Defined SQL there which returns about 20 lakh records passed to the join stage.

I changed the values of APT_MONITOR_SIZE and APT_MONITOR_TIME but still getting a broken pipe error. It's strange that when I replace the join stage with a lookup stage my job runs successfully and loads the data to the sequential file.
Any help regarding this issue will be greatly appreciated.

APT_NO_JOBMON is set to false and APT_RECORD_COUNTS is also set to True. I have explicitly included these variables in my job and set their values. Still I am unable to see the record counts in my job. It only shows 0 rows.

I don't see any port 13400 or 13401 when I issue the netstat -an command

Hello, I have a requirement to capture the names of the source and target tables/files used in the parallel job. For Example: If I have 3 sources A,B and C, I need to assign A|B|C (concatination of Source Table Names A,B and C) and store it in a parameter and later assign this value of the parameter...

I have a parallel job which runs successfully..imports required no. of records (as shown in the job log) into the sequential file. But in the designer, it does not show any job statistics. Even though my job ran successfully I cant see the no. of rows passing through each stage. Job monitor also doe...