can we create index and drop index in exsisting table while using infomatica

can we create index and drop index in exsisting table while
using infomatica

Question Posted / d

4 Answers
18778 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

can we create index and drop index in exsisting table while using infomatica..

I know 4 ways in INFORMATICA

1)Source Analyzer window-
(source table,Using key ports(enable,disable)).
2)Source qualifie Trans-
(Sql override)
3)Target override
4)Pre sql,Post sql

Any corrections,, srinu.srinuvas@gmail.com .

Is This Answer Correct ?

11 Yes

0 No

can we create index and drop index in exsisting table while using infomatica..

Answer / roshan

one more way is to write stored procedure and use target pre load and target post load option using unconnected stored procedure T/R...
for more detail
infernonag@gmail.com

Is This Answer Correct ?

3 Yes

0 No

can we create index and drop index in exsisting table while using infomatica..

Answer / rekha

YES

Is This Answer Correct ?

3 Yes

1 No

can we create index and drop index in exsisting table while using infomatica..

Answer / amarnath

when you import a target into designer you have an option
to drop constraints or create it and some other options as
well. go and edit the target u will fins all the options.
u can drop constraints and index before loading and re-
create it after the load with these options. this is the
simple method provided by informatica.

Is This Answer Correct ?

1 Yes

2 No

Post New Answer