Search results for query: *

Hi, This is my problem: i have a source table that have 3 fields: id, column_name, column_value. The problem is that i have to do, using OWB, an update of a target table with the information of my source table. In pl/sql it would be easy to do an update of a variable field but how can i map...

Hi! I need to change user during a procedure. I tried this way: FOR I IN EXECUTIONS.FIRST .. EXECUTIONS.LAST LOOP IF UPPER(EXECUTIONS(I).EX_COMPTE) <> UPPER(COMPTE_COUR) OR COMPTE_COUR IS NULL THEN REQ_EXEC := 'CONNECT :1/:2@UNIF'; EXECUTE IMMEDIATE REQ_EXEC...

Hi, Do somebody knows how to do a SELECT COUNT (DISTINCT field1||field2) in OWB? In my mapping, i have an aggregate that makes a 'GROUP BY' and four 'SUM', and in the expression field OWB doesn't give me the 'DISTINCT' option (I have to make a COUNT of distinct NAS). My superior don't want me...

Hi, Can somebody tell me what is the difference between INSERT/UPDATE and UPDATE/INSERT ? Another question: why, when i do an update/insert or insert/update, OWB give me an error 'constraint key violated' when a row in the target table needs to be update 2 times or more? (2 rows with the key...

Hi, I wonder if somebody have a tip for this problem.. I have to link a field of my source table in another field of a temporary table, but the source table have over 200 fields and i can't scroll down enough to catch it in the mapping...

Hi all! I have this problem using Oracle Warehouse Builder: In my source table, i have this key: No_usag, typ_sdu and seq_sdu. This is call a 'SDU'. In my target table, i want more than one record by SDU, per example: SDU NAS FEF CA 1111111111TQ0001...