DSXchange

Hello,

Server job is aborted with the following error : ReportWIPRMJ1..TRF_ReportWIPRm: ORA-01002: fetch out of sequence

Please suggest.

Thanks in advance.

Hello Team, My source has only 4 records and the reference has 10K+ records. I am using sparse lookup. More than 4 records are flowing out of the lookup to the next stage. I have used below properties in lookup stage: 1. Condition not met : Fail 2. Lookup failure : Reject I want only 4 records (matc...

Thank you Teej

Can you pls explain me with some example...
for eg: my input date : 23-MAY-15.. i need to add 17business days (Monday to friday). Please help me on this and thanks in advance.

Thanks Chulett

Thanks all!!!!!!!! I want to exclude only weekends. Holidays is not mandatory. I tried with 14calendar days which gives 10business days(Monday to Friday) and its working fine. But my requirement, not only 10 business days...some places i have to use 14,17,21 business days. So I want to implement thi...

Hello everyone, I want to add 10 business days to one field which is timestamp datatype. I tried in SQL like below Select add_business_days(timestampfieldname,5) as A from XYZ. But it is saying invalid identifier. So I want to implement this logic in my job using some stages. I know we have some fun...

Hi All, We get the error and the job aborts when array size and record count is set to 65000 on ODBC stage-Insert Bulk failed due to schema change on target table. Observation - new nullable columns are added to the table after we developed the job. These new columns are not defined in the job but a...

Hi All, In datastage we are calling stored procedure to load the main tables from staging tables. our job looks like row_generator -> transformer -> stored procedure stage -> output file We are creating and passing input parameter to stored procedure and also passing the status to output file using ...

Hi All, I am using a sequencer to run all of my parallel and child sequence jobs. In master sequence, am calling two parallel jobs and one sequence job. In child sequence, am executing script. If suppose the child seq gets aborted, then my master also gets aborted. When I tried to compile and re-run...

Thanks to all..The problem is resolved now. Actually the problem is with my input files. I have read two files, so DS is reading the file in parallel mode eventhough in transformer the execution mode is sequential. I am not sure about the problem. But now I have concatenated the input files and read...

Hi Chulett, Thanks for ur reply. I need to create two output files as mentioned. File_1 is correct that is the output value is 1,2,3. But the file_2 is like 0,2,3,1,0. But for the single node or 2node, the output is perfect. I am doing any partitioning inside my job. I am reading the data sequential...

Hi All, I am reading two files in CFF stage. After that, generating sequence number using transformer stage with nextsurrogatekey() function. And I need to create two files. Input data: A000000000000000000 B000000000000000000 B000000000000000000 B000000000000000000 A000000000000000000 B0000000000000...

Hi All, I have used CFF stage in my job to read a mainframe file. I have used one file which is having multiple record type. Is there are any possible to read one more file in the same job? If yes, then what are changes I need to do in my job? They required same metadata or different? If the second ...

Hi All, I have two different files. I want to merge two files but I don't have any common keys. So I have created a dummy key to merge two files. Master link having 13rows and reference having 5rows. But after merging, I am getting only 17rows. One row is missing. Please help me to get 18rows in my ...

Hi Andy,

Thanks for ur help. My problem was resolved. Actually the problem is with my data. Now its working fine. Thanks once again.