DSXchange

Hi Ray, It's my mistake.I have not properly migrated the job that creates the dataset [this dataset has the column for aggregation] and moreover the developer has typed the column in the aggregator stage rather the selecting it from the listbox.I have corrected it and ran the job it worked fine. I h...

Hi All, Issue:-Below is the dump I received when I try to run the job in production. It uses a dataset,aggregator,dataset stage. I need to calculate the Maximum value of a date column group by a Column[No composite grouping keys]. I ran the same code with the same volume of data in Dev, the code is ...

Hi All,

Thanks for all your inputs. Apologies for the delayed reply. There is an option in the oracle connector stage "Insert new rows only". I am not going to perform any updates.

Regards,
Bala

Hi All, Requirement:A Delta extract will change to full extract at a specfic time period[Eg:say every 3 months].It will have the same version of the records in my datawarehouse only during that time period. My approach:I am changing the write mode from insert to upsert in my oracle connector stage ....

Thanks Ernie and Craig.Valuable information. My requirement is similar[performing inserts,updates and rejects from the same transformer source] but not exactly real time in nature. Also, I need to wait for the unit of work[rejects] to get completed for the job abort to occur and at the same time sto...

Hi All, Kindly help me in understanding the concept of the wave generator stage. Requirement: ======== Need to abort the job after inserting 'n' number of records into the reject table. Design: ===== 1.Filtered the records based on the reject criteria and threshold and inserted into the reject table...

Hi, Small clarification. My understanding:If we issue two different DML statements into two different Oracle Connectors then ideally depending upon the commit interval which I set in each Oracle Connectors, the transactions will get commited even if the job fails. Correct me If i have misunderstood....

Thanks Andy,kim I don't see any open endness in the question.It was very specfic that staging the jobs in intermediate datasets allows modularity in design but resource usabilty,I/O speed need to be optimized.If anyone has done this optimization earlier are most welcome to share their views. Andy:-I...

Hi All, We are in the process of standardizing datastage design techniques. When it comes to modularity, I/O issue was raised. Can I get some inputs on what are the pros and cons of modular designing versus designing in one single job in terms of speed and resources. Since modular designing involves...

Thanks its working.We can use LIKE operator in Filter Stage.
Eg:- col3 LIKE '%ABC%'

Regards,
Bala.

Hi All, A small clarification.Is there any functions or suggestions to implement the LIKE operator in datastage. Eg:-Select col1,col2 from table1 where col3 LIKE %ABC%. I am converting some sql scripts to datastage jobs,the issue is I have to implement the LIKE part also in datastage because the sou...

Hi All, I am pivoting some columns into rows using pivot. Anybody has encountered this warning. Invalid character(s) ([xA9]) found converting string (code point(s): IBM Confidential, OCO Source Materials, [xA9] Copyright IBM Corp. 2006. All Rights R...) from codepage UTF-8 to Unicode, substituting. ...

Hi,

Yes.Even in previous version of datastage(8.1) it was running. We are passing some values(user_id,password,DSN,schema) through parameters

Thanks again for the inputs.

Regards,
Bala.

Thanks Sai, Yes I did view the data it got viewed properly. couple of other testing also I have done The query has 5 union queries. 1.If I remove all the unions then the job runs fine 2.Also, I introduce only one union in next testing, then the job is not getting completed. Anything can figured out ...

Whoops! typing error OracleOCI9 for server jobs.