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

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

630


What are the differences between source qualifier and joiner transformation?

594


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

1527


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

1276


What is a standalone command task?

652






Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1836


What are the types of data warehouses?

936


What is a shortcut and copy in Informatica and how two are different with each other?

670


What are the reusable transformations?

694


How do you load first and last records into target table?

660


Mention few advantages of router transformation over filter transformation.

633


what is mean by complex business rule ?

1718


How do you remove duplicate records in informatica? And how many ways are there to do it?

709


If informatica has its scheduler why using third party scheduler?

769


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

600