DSXchange

Hi,

It has been defined as decimal(38,8) in Dataset.






Thanks.

Hi All, When i try to execute the below query in sql developer/Toad it's fecthing the required results. DATE1 & DATE2 is date datatype in oracle SELECT nvl(abs(to_date(DATE2,'dd/mm/yyyy') - to_date(DATE1,'dd/mm/yyyy')),0) as DATEDIFF, FROM TABLE; But, when i try the same in Oracle Connector in D...

Hi All,

Do you have any idea on how to find the previous business/working day from the given date. is there any inbuilt function available or do we need to write any routine...


Kindly let me know your thoughts on the same.


Thanks.

Hi Chulett, I apologize for not mentioning that in the previous post. Yes.. i ran the query outside of datastage(Toad) without having the case statement on it, it ran fine and fetched the results. While using the case statement and run it again using Toad..it came out with the below error ORA-01652:...

Thanks Chulett, I am just running the below query in sql developer select col1,col2,col3 from DIM_CUSTOMER; Returns - 110000 rows when i tried to run the same query using Oracle connector(for extract using one node(sequential/ or parallel(using 2 nodes)) and put it into the Dataset..the job is runni...

Hi Chulett,

When i try to run the normal query(simple select) in sql developer, it resulted rows within a minute.

But the same query has been run forever in DS jobs using oracle connector stage.



Regards,
Satheesh

Hi Chullet,

Oracle is the DB.

As i am doing a left outer with 5 of the tables and doing the case statement(almost 5) would eat up the whole temp space.

For me, t's tricky with datastage to attain the same.

Regards,
Satheesh

Hi All, I would like to obtain the result for the below transformation using sql statement, as we have millions of rows in the tables..while executing the whole tempspace got filled up. CASE WHEN obj.Id=8 THEN ( COUNT(DISTINCT CASE WHEN act.code = 'DEL' THEN acc.item ELSE NULL END ) ) ELSE 0 END as ...

Hi Team,


We have a requirement, we were generating seq.nextval key through DB insert statements. Is there any way can we capture the same key value with the same job.


kindly let me know your thoughts on the same.



Regards,
S.R

Hi Craig / Ramesh,


Yes..I have used CDC stage to get that done. Thanks for your valuable inputs.


Note: Took a week off..and haven't used my laptop for almost a week. :D




Regards,
S.R

Hi Craig, It is not really SCD Type2. Always we will need to insert a new row to treat it as new record eventhough some columns has been updated as we are doing incremental load. Eg1:Yesterday record: Insert the below row into Cust_Addr_Dim as it has not the below value in dimension Customer,Order_i...

Hi All, I have the below scenario, I have to build(insert) the address dimension as per the below scenario 1. Compare values(Addr1,City,State,Country,PostalCode) against existing customer address dimension(Addr1,City,State,Country,PostalCode), no key columns. if it is not available then insert. I ca...

Hi Ray, ;;QualityStage v8.0 ;------------------------------------------------------------------------------- ; Pattern-Action File ;------------------------------------------------------------------------------- ;------------------------------------------------------------------------------- ; Parse...

Hi All, I am validating address for ine1 and Line2 and using custom ruleset. Below values has been set in .PAT file \PRAGMA_START SEPLIST " ~" STRIPLIST " `!@#$%^*()_+={}[]|\\;\"<>?" \PRAGMA_END When i try to get the below value for Line1 Source: BLDG: CCA6, CUBE 6.7.270 But...

Hi Ray, Thanks. When i try to use USAREA ln_std_adr.CityName_USAREA has all the values. ln_std_adr.StateAbbreviation_USAREA is set as null and so on. Eg: HOUSTON TX USA(ln_std_adr.CityName_USAREA) Eg2 for Canada: SAINT BRUNO QC CAN (ln_std_adr.CityName_USAREA) ln_std_adr.StateAbbreviation_USAREA,ln_...