can we create index and drop index in exsisting table while
using infomatica
Answer Posted / 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 View All Answers
difference between informatica 8.1.1 and 8.6
difference between repository database and repository service?
What is the difference between Active and Passive transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is decode in informatica?
Tell me about MD5 functions in informatica
What are the advantages of informatica?
What can we do to improve the performance of informatica aggregator transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
When do you use sql override in a lookup transformation?
Explain the code page compatibility?
Slowly changing dimensions, types and where will you use them
r u done any partitions in ur project?
What is source qualifier transformation in informatica?
Define mapping and session?