You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » [resolved] ETL? ELT?
Post a reply
Topic review (newest first)
- shong
- 2010-03-22 09:53:39
Hello
As the error message shows, there retusn more than one rows..
here :
SELECT key, value
FROM MU INNER JOIN MU ON M.key = MU.key
WHERE M.value <> MU.value
AND M.key = MU.key
return more than one rows.
Best regards
Shong
- mbecerikli
- 2010-03-22 08:07:22
Can Anybody (cantoine, esabot, shong) Help Me ???
- mbecerikli
- 2010-03-18 09:31:28
NO COMMENT ???
- mbecerikli
- 2010-03-17 16:25:36
OK!!!
I tried ELT and got this error:
Exception in component tELTOracleOutput_1
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
at sbm_etl_project.testmedia_0_1.testMedia.tELTOracleMap_1Process(testMedia.java:277)
at sbm_etl_project.testmedia_0_1.testMedia.runJobInTOS(testMedia.java:484)
at sbm_etl_project.testmedia_0_1.testMedia.main(testMedia.java:377)
I know that it means. My SQL statement is ;
UPDATE M
SET (key, value) =
(SELECT key, value
FROM MU INNER JOIN MU ON M.key = MU.key
WHERE M.value <> MU.value
AND M.key = MU.key)
Table M and Table MU have same structure. I just want to update "MU.value" column, if "M.value" has changed (base on the "key" column).
I do not know how upload an img to the topic (here). So I couldnt upload my job's screenshot.
CAN ANY BODY HELP ME ???
- mbecerikli
- 2010-03-17 10:35:54
Hi,
I have 2 aplication that have each database but the users and their passwords are same for each database.
I do not have a LDAP structure and I have to syncronize two USER_INFO table (especially passwords)!
Which way is more sensible to achieve this:
ETL (tOracleInput, tOracleOutput, tMap) or ELT (tELTOracleInput, tELTOracleOutput, tELTOracleMap) ???
After the desicion of this question, I will focus the more spesific issues...
Thanks a lot,
Mevlut.