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

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1919


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6438


Performance tuning( what you did in performance tuning)

1724


How to create Target definition for flat files?

990


What do you mean by worklet?

839


Explain the different kinds of facts.

761


What are the new features of informatica 9.x at the developer level?

829


Explain sessions?

779


Suppose we do not group by on any ports of the aggregator what will be the output?

825


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2138


Why sorter is an active transformation?

966


What is option by which we can run all the sessions in a batch simultaneously?

885


What is aggregator transformation in informatica?

748


How can we create index after completion of load process?

839


Differences between version 7.x and 8.x.

1652