DSXchange

We have an input dataset that feeds into a parallel transformer stage with as many output links as dimension lookups required. If 3 such lookups needs to be performed (and the matching surrogate key returned from the dimension), then the transformer output has 3 links. Within the transformer stage, ...

Thanks ..Will try this out..
Is it similar to the cast function we have in oracle ?

Btw, I like the signature you have there

We have a oracle source number field coming in with number(19,4). In the target, the same has been defined as number(21,6) And there are a lot of number fields like this in our tables. Our ETL job expects a volume of 1 million rows everyday to be loaded from the source to the target. Now, I know tha...

Hi Gaby, Apparently, load option using parallel stage has some bugs in datastage that has prevented us from using it... We have given this information to IBM and it is being ackonwledged by them it is indeed a bug and last heard from them was that they are working on it... No other oracle stage is r...

Hi, We are facing similar CDC related performance issues in some of our heavy volume jobs... The scenario for us is : target dimension has about 20 million records. Incoming source data(oracle) has a total of 20 million records.. Since the source is not a fact, there seems to be no way to filter the...

Issue:- Oracle deadlock issue problem while inserting data into ORACLE DB. sqlcode is: -60 esql complaint: ORA-00060: deadlock detected while waiting for resource Issue in detail:- I am using the parallel ORACLE enterprise stage in my load job to load the transformed data. During load I am facing de...

Thanks to Minhajudin and Craig... Now, I have more than one idea to play with... The reason why I detest cross application dependancies at scheduler level is the very very tight dependancy it creates on more than one application...but, some times, to keep things simple, this is the way to go...and i...

Thanks Criag, I guess you are bent on not answering my question! :roll: :wink: I do not unfortunately participate in the decision making process of requirements... I just try my best to abide by the decisions...and if they are silly, then I question them...but, this requirement is not something ridi...

Thanks Criag, I guess you are bent on not answering my question! :roll: :wink: I do not unfortunately participate in the decision making process of requirements... I just try my best to abide by the decisions...and if they are silly, then I question them...but, this requirement is not something ridi...

thanks for all the responses... I have thought about doing what Craig had mentioned... But, its a requirement that enforces us not to have a cross application dependancy at the scheduler level directly... text file option has also been thought about...i know we can use the WaitforfileActivity...but,...

Nobody got any ideas

I have a question regarding polling within datastage. The specific criteria being that we are required to trigger our datastage jobs(a master sequence rather) based on the successful completion of certain jobs from an existing application that is built using oracle as the database. Our master sequen...

Thanks a lot for the response... I have been able to progress a lot based on the inputs... However, I have more questions... I have read in your other posts that: You do not have to call DSJobReportDbDriver at all if you want. You can run DSJobReportDb directly. DSJobReportDbDriver was created so at...

Hi , I had a some questions on etlstats: I had imported the dsx file. 1) The install.txt specifies creating files in TCL prompt. Are these directories created under unix etl server? Our environment is usually constrained to allow creating additional folders since a project is allocated at a minimum ...

Suppose I do not want to install the whole package of etlstats to my project, would i be still able to leverage just the dsjobreportDB features of inserting stats into the table...? I am interested in the stats that are in etl_job_hist (start,end times, status etc)... I guess what i am trying to get...