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

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6093


What is the fact table?

593


Explain the tuning lookup transformation - informatica

615


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1644


What are the types of caches in lookup?

572






How you can differentiate between connected lookup and unconnected lookup?

615


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1974


Define Pmrep command?

642


How to use pmcmd utility command?

584


Under which circumstances, informatica server creates reject files?

593


Explain the difference between a data warehouse and a data mart?

600


what is the hint? how to use it to reduce the query processing in program?

6320


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1338


Explain pmcmd command usage in informatica

708


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1622