Interested to Buy Any Domain ? << Click Here >> for more details...
can we create index and drop index in exsisting table while
using infomatica
- 4 Answers
- 19979 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
What is an unconnected transformation?
What is confirmed fact in dataware housing?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What do you understand by term role-playing dimension?
How are indexes created after completing the load process?
What is the scenario which compels informatica server to reject files?
What are the prerequisite tasks to achieve the session partition?
What does reusable transformation mean?
What is the use of an aggregator cache file?
Explain pushdown optimization and types in informatica
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Differentiate between a repository server and a powerhouse?
can we override a native sql query within informatica? Where do we do it?
What are the components of workflow manager?
Differentiate between sessions and batches?
