can we create index and drop index in exsisting table while
using infomatica

Answer Posted / roshan

one more way is to write stored procedure and use target pre load and target post load option using unconnected stored procedure T/R...
for more detail
infernonag@gmail.com

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the tasks that source qualifier perform?

722


Define mapping and session?

676


Explain what is informatica metadata and where is it stored?

690


Target increases every day even though no new record was inserted

1221


How might one distinguish in the case of mapping is right or not without associating session?

733






I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1303


What do you understand by SOA of Informatica?

668


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1707


What is the function of union transformation?

713


What is primary and backup node?

803


Difference between Target-based loading and constraint-based loading?

646


In development project what is the process to follow for an etl developer from day1

1372


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1764


What can we do to improve the performance of informatica aggregator transformation?

716


What are the types of lookup transformation?

724