DSXchange

[quote="shivajid2k"]Try by removing the parameter set from the job and add it again..compile and run..[/quote] The job runs fine if i compile and run it. The issue is with recompilation. I have a ton of jobs which use the parameter set. I am looking to avoide the recompilation whenever the...

Hi, Changes made to the parameter set are not reflecting in the parallel jobs. The parameter set has username,password& schema. Below is the sequence of events where i am facing issue. 1) Compile & run the job successfully. 2) Change the password/schema name in the parameter set. 3) Run the ...

I need to convert Julian dates from source to Oracle Timestamp in the target. Sample Source:- 109001 [Number(6)] Target required value:- 01/01/2009 concatented with 0's for time part. 000001 refers to 01/01/1900. I have found few posts regarding julian dates but wasn't very clear. I found a function...

I intially developed the job with a Netezza Enterprise target. I had to disable RCP as Netezza Enterprise was failinig because of it. Then i changed the target to sequential file and all the records were beig rejected. I re-enabled the RCP and the job is running fine. IBM guys say that enabling/disa...

Hi The sequence of the stages in my job is as below Seq_File_Source--->Transfomer--->Lookup--->Seq_File_Target Not even a single record is getting inserted into my target sequential file. Selective text from job log of director which might be helpful 1)FIN_HDR,0: Import complete; 516 records importe...

I would have the same no of Transformer stages but atleast i can avoid Lookup stages. So how do i start to write the routine?

Hi I have a situation where 1 sequential file populates 40 target tables. As i am using "External Filter stage" in my stream and other reasons i cant do a generic lookup before i split the data to 40 targets. The temporary solution for this is i used 40 Lookup Stages one for each traget. T...

Hello my sample data looks like below |77.2.0.153.1.1|77.2.0.153.1.1|0x3|0|0|1 --------------Header for each row |0|68------------Part of Header |7|52|47408---------Data & the Format is Table_No|Column_No|Value |7|53|0 |129|66|6 34 59 34 34 44 28 |129|67|6 34 59 34 34 44 28 |129|68|6 0 0 0 0 0 0...

Hello I recieve a file every 5 minutes(24x7). They are all of the same filetype and processed by the same job. The sizes of the files might vary. For example file1 might be 10MB and file2 2MB. The issue is i dont want to the stage the files and run one after another waiting for the previous file to ...

I dont have any header/footer. Also i dont have any after/before job subroutines.

Hi sseths can you tell how you obtained the patch. I have the same issue. We are not able to see the options like maxerrors in Netezza Enterprise.

Hi Ray

Thanks for the quick reply. Is that the only option left. My requirement is to poll and ftp lot of files. I am looking to achieve this without any/minimal scripting.

I am concerened that if i use command i have to look for completion of the ftp transfer process etc.

Chullete i think transfering of file is different from transfering data. By latter i mean reading data from remote file and write to the destination file. For example if the remote file is zipped how do you read data and recreate the destination zip file. I am looking for the conventional ftp functi...

By weird i meant weird in this context. The maxerror count has the default value of 1.


If all the records are loaded in the target where is the scope for bad/error records.

Hi, My parellel job runs successfully. It loads the expected 100 rows to the target. I have verified the target table. But the status of the job becomes 'Aborted' after the run. So i cant re-run the job. I am using Netezza database as target. I am getting a weird error "count of bad input rows ...