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 substr in informatica?
Briefly define reusable transformation?
Design a mapping to load a target table with the following values from the above source?
What are mapplets?
Is there any way to read the ms excel datas directly into informatica?
What is the scenario which compels informatica server to reject files?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Can anyone tell me the new features in Informatica 9 Version?
difference between repository database and repository service?
How do you load alternate records into different tables through mapping flow?
How you can differentiate between connected lookup and unconnected lookup?
How to join three sources using joiner? Explain though mapping flow.
Different circumstance which drives informatica server to expel records?
Tell me about Propagate functions in informatica
what are factless facts? And in which scenario will you use such kinds of fact tables.