DSXchange

Scenario is as follows: Old Access DB schema COL_NAME DATA_TYPE 'HAIR' Yes/No 'FACE' Yes/No 'LIP' Yes/No 'ORAL' Yes/No 'ID' (PK) Text New database design schema: COL_NAME DATA_TYPE 'ID' VarChar (PK) 'PRODUCT_TYPE' VarChar (PK) Question: How can I check the 'Yes' columns from the old schema and inser...

Hi Ray, My apologies. Will post the second qn on a new thread. Can you kindly advise regarding date comparison query first? With regards to the routine you advised me to write, I am converting from a Access DB and the type is Date/Time, think that's why Iconv was not successful. In this case, how ca...

Hi both, Thanks for the info. It is definitely because of the data like what Vincent mentioned. I am converting from a Access DB and the type is Date/Time, think that's why Iconv was not successful. In this case, how can I convert it into a string format?? I checked out the built-in routines such as...

Trying to do a date comparison here. Applied the following code but works the other way round: if (Iconv(Input.InputDate, "D/MDY[2,2,4]") > Iconv("07/01/2001", "D/MDY[2,2,4]")) then "A" else "B" The records with input date later than 1st July 2001 st...

Hi all!

Thank you so much for the help!

[:)]

Newbie here. Trying to set sysdate value in the one of the columns in transformer stage for loading into Oracle9i DB. The destination column is in Timestamp type. Which function/system variable should I use? I have tried the following: @DATE, Date(), TimeDate(). All of which returns a string literal...

When I do a direct extraction from Access to a sequential file, the chinese characters appears as "??" in the text file as well. Any further advise? As for question 1, what should be the correct code page setting? Because my DBA is not around today and I am only familiar with basics of Dat...

I am trying to transform and convert a set of data from MS Access to Oracle9i. The data contains chinese characters. Seen from one of the posting here that I should use set NLS map to BIG5 or GB2312, tried both but did not work for me. I was not able to view the source data. All the chinese characte...