If you want to create indexes after the load process which
transformation you choose?

Answer Posted / kalyan

use the post session SQL to craete indexes on the target
table..

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many ways a relational source definition can be updated and what are they?

777


How is union transformation utilized?

757


Explain dynamic target flat file name generation in informatica

824


How does a rank transform differ from aggregator transform functions max and min?

888


Write the advantages of partitioning a session?

966


Partition, what happens if the specified key range is shorter and longer

2206


How many input parameters can exist in an unconnected lookup?

1261


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5328


What is informatica etl tool?

720


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6845


What is meant by lookup transformation?

780


What is the difference between a repository server and a powerhouse?

1118


How to update or delete the rows in a target, which do not have key fields?

880


What is meant by active and passive transformation?

774


What are the steps involved in the migration from older version to newer version of Informatica Server?

1814