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
What is olap (on-line analytical processing?
server hot-ws270 is connect to Repository B. What does it mean?
Which transformation should we use to normalise the COBOL and relational sources?
Explain why we use partitioning the session in informatica?
How do you change a non-reusable transformation to reusable transformation?
What is event and what are the tasks related to it?
Differentiate between joiner and lookup transformation?
where to store informatica rejected data?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Explain lookup transformation in informatica
What does role playing dimension mean?
What can we do to improve the performance of informatica aggregator transformation?
Explain how many types of dimensions are available in informatica?
Why sorter is an active transformation?
What is joiner change?