DSXchange

Thank you both for your replies.
Both replies are good enough for me !
:D

Hello, I need to check if a column data is numeric or character. the data I get can only come in 2 ways for that column number or varchar2 ( the datatype of the column is ofcourse varchar2 ) I thought I'll just check for the ascii range of the first character ( If it is not between Ascii(48) and Asc...

Hi All, I'm have 2 tables A: have person age B: A certain id for age range. meaning : Person with age value of 24 in table A will mean in table B id : 3 start_age: 20, end_age: 25 so when I join these table in SQL and ask for the id the sql statement will look like this: select b.id from a,b where a...

baigdw wrote:: You can use a customized sql to handle your insert/update statement.

Thanks baigdw,

Using customized sql solved the issue.

And thanks to everyone for their comments

Hello, I have a table that I'm inserting/updating . I want to add two columns one 'Insert_date' and 'Update_date' How can I make sure that the insert column is not updated and will only only be loaded once ( When the record is created ) I do not want to split my DS into seperate operations i.e. - on...

Hi All,

You are both absolutly right !!!

The Job run perfectly well and indeed I cannot view the Data with the 'View Data' button.

Thanks for the help, I learned alot about DS from this one

jzparad, this is the error message I get when I try to 'View_Data' : ' DS_DIM_LANGUAGE..Oracle_OCI_15: ORA-08002: sequence SEQ_LANGUAGE.CURRVAL is not yet defined in this session DS_DIM_LANGUAGE..Oracle_OCI_15.DSLink1: DSP.Open GCI $DSP.Open error -100.' the job Is Set : Oracle_source, Oracle_select...

Hello, For a certain table I need to create a surrogate key. I created a sequence in Oracle .... Now How can I import this sequence into DS ? I tried doing it with : 'Select seq.nextval from dual' but that failed ! I donot want to have a DS Internal sequence as I do need this sequence accessible. Th...

Thanks, that works just fine

Hello, I have 2 tables: 1. Country 2. Language In the country table for each Country there are ALL the languages available - meaning: Country = FR Language = US,NL,DE .... Country Language FR______US FR______NL FR______FR What I am trying to create is for each country only the relevant languages + E...

Thanks all for replying.

I eventualy decided to embed this calculation in the way I derivr the column from the DB.

Thanks.

Hello, How can I calculate a person age using dates in a transformation in SQL it would look something like that : SELECT round((SYSDATE - to_date('01/01/2005','dd/mm/yyyy'))/365) FROM dual I have the birthdate of the person and in order to calculate the age I'm substructing the birthdate from SYSDA...

From what you say, this looks very much like a lookup. You supply the key, it returns a value. If so, why not create an Oracle function which you can then call from an OCI stage using a simple "select fn(:1) from dual" and use the OCI stage as a lookup. Thanks, I didn't think of that. I a...

Well to be accurate, I'm not sure what exactly you are reffering to. I open anew server job and drug'n'drop the stored procedure ICON from the pallete --> I create a transformation --> and a target table. I map the procedure results( I think ) to the proper target column. Hope this helps to clarify ...

Just to confirm are you actually using the stored procedure stage or have you written a job which gets data from a stored procedure.[/quote] I'm Using a Stored procedure stage, But if you have any suggestions on how to implement the stored procedure into a regular job and getting the necessary resul...