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
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 ?
What is the fact table?
Explain the tuning lookup transformation - informatica
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the types of caches in lookup?
How you can differentiate between connected lookup and unconnected lookup?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Define Pmrep command?
How to use pmcmd utility command?
Under which circumstances, informatica server creates reject files?
Explain the difference between a data warehouse and a data mart?
what is the hint? how to use it to reduce the query processing in program?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain pmcmd command usage in informatica
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?