can we create index and drop index in exsisting table while
using infomatica
- 4 Answers
- 18780 Views
- I also Faced
- E-Mail Answers
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
Write the different tools in the workflow manager?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Explain sessions. Explain how batches are used to combine executions?
What is the session task and command task?
What is DR strategy for Informatica project?
what is informatica metadata?
What is workflow? What are the components of the workflow manager?
Does an informatica transformation support only aggregate expressions?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is a repository manager?
Is it possible to create multiple domains on a single Informatica server?
Explain Dataware house architecture .how data flow from intial to end?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Explain about cumulative Sum or moving sum?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
