edward_hall76 (7/14/2012)

---

Right now I have been asking people who the phone carrier is and can just add it to the end of there number. But I was trying to find...

Welsh Corgi (7/14/2012)

---

I need to get a record count from an Oracle Table and store the values in a log table before and after the load (OLE DB).

I need to...

prvmine (7/11/2012)

---

something like

to_char(QD_RDB_ENTRY_DATE, 'yyyy-mm-dd 'HH24:MI:SS.FF7')

you might have to remove the 24 from the HH portion depending on how the instance of oracle is configured

Sql Server datetime2(7) is the largest fractional...

herladygeekedness (7/12/2012)

---

akirajt (7/7/2012)

---

Should the surrogate key, for instance customerKey for dimension customer, be created in the stage process and then the all data should be loaded into the dimCustomer or...

I'm sorry for the delay.

You are correct, runInstaller is for Unix/Linux - as you figured it out setup does it for Windows.

In regards to the sqlplus error be sure environmental...

Oracle home can be specified at the command line, like:

./runInstaller ORACLE_HOME="OH_location" ORACLE_HOME_NAME="OH_name"

Hope this helps.

Please do sp_help table_name and post results; we trying to figure out the already existing constraints in such a table.

Either constraint already exists or creation of the constraint is creating...

Elizabeth Good (5/4/2012)

---

I would also run logical backups (exports or datapump exp) fairly regularly. These are very helpful for "oops" moments-someone deletes a table accidentally, etc.

Also, setting up a...

... select top 3?

sambireddy chirra (6/26/2012)

---

Hi All,

I have two tables, Employee table have master data and Employee_Details have transactional data.it has added EmpID with row number. how to join two table based on...

foreverloops (6/26/2012)

---

Hi,

I work for an organisation where we have approximately 75 IT staff. We have a development team, an application service team and an infrastructure team who jointly support MS...

muthyala_51 (6/19/2012)

---

Can any one give me syntax of Updating an oracle table using Openquery. I will be running this query from SQL Server Management studio.

Is this correct?....

UPDATE OPENQUERY (Ora_link,

'SELECT Flag...

DBA_AUS (6/20/2012)

---

all i am trying to do is copy data from a table from SQL Server to Oracle. table has 5000 rows only but ssis package takes ages to complete...

Well... if TNSNAMES is changed to point to a different database I would also want to re-initialize; new database, new replication schema.

dj1202 (6/15/2012)

---

PaulB-TheOneAndOnly (6/15/2012)

---

dj1202 (6/15/2012)

---

Hello all, I am creating a table, named DimCalendar, which has the following columns:

DateID (date)

Quarter

Year

Month

Week

Day

InvoiceNumber

There are duplicate dates in the DateID column, but I would like to...