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


Please Help Members By Posting Answers For Below Questions

What is substr in informatica?

927


Briefly define reusable transformation?

867


Design a mapping to load a target table with the following values from the above source?

1124


What are mapplets?

1038


Is there any way to read the ms excel datas directly into informatica?

797


What is the scenario which compels informatica server to reject files?

859


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

1699


Can anyone tell me the new features in Informatica 9 Version?

1814


difference between repository database and repository service?

860


How do you load alternate records into different tables through mapping flow?

1614


How you can differentiate between connected lookup and unconnected lookup?

852


How to join three sources using joiner? Explain though mapping flow.

915


Different circumstance which drives informatica server to expel records?

767


Tell me about Propagate functions in informatica

736


what are factless facts? And in which scenario will you use such kinds of fact tables.

1550