Thanks Kirti for the suggestion..it works now.
Sathish.
On Mon, 14 Oct 2002 19:53:23 -0800, Deshpande, Kirti
[EMAIL PROTECTED] said:
Create logon triggers for these Informatica user id to alter session
set...
- Kirti
-Original Message-
Sent: Monday, October 14, 2002 7:09
In Informatica there is a stored procedure transform (runs any Oracle SP)
that you can make it pre source load.
So the SP would be called before loading the table.
Regards,
Waleed
-Original Message-
Sent: Monday, October 14, 2002 7:04 PM
To: Multiple recipients of list ORACLE-L
Hello
Thats what we exactly did except that iniformatica starts a separate
session when it is loading the target
which results in the error unusable state .
sathish
On Mon, 14 Oct 2002 15:44:02 -0800, Khedr, Waleed
[EMAIL PROTECTED] said:
In Informatica there is a stored procedure transform (runs
Create logon triggers for these Informatica user id to alter session
set...
- Kirti
-Original Message-
Sent: Monday, October 14, 2002 7:09 PM
To: Multiple recipients of list ORACLE-L
Thats what we exactly did except that iniformatica starts a separate
session when it is loading
Why do you have to make the indexes unusable?
Can't you do a direct load into the table (nologging mode)?
Waleed
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/14/02 7:08 PM
Thats what we exactly did except that iniformatica starts a separate
session when it