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
Explain target update override in informatica
What do you understand by a term domain?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is a filter transformation?
What is the procedure for creating independent data marts from informatica 7.1?
What is resilience time?
What are data-driven sessions?
What are the features of complex mapping?
How to do unit testing in informatica?
Explain how many types of dimensions are available in informatica?
Which development components of informatica have the highest usage?
What could be the possible resons of locks by user?
What is Cognos script editor?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are the designer tools for creating transformations?