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 do you mean by DTM and Load manager and what is difference between load manager and load balancer?
define galaxy repository in informatica
what are factless facts? And in which scenario will you use such kinds of fact tables.
How do you promote a non-reusable transformation to reusable transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Differences between version 7.x and 8.x.
tell me the rules and responsblites in our project(my project is development)
What is the difference between STOP and ABORT options in Workflow Monitor?
Can u generate reports in Informatica?
What is a repository manager?
explan ur project architecture?
Explain the informatica workflow?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to use procedural logic inside infromatica?