If you want to create indexes after the load process which
transformation you choose?
Answers were Sorted based on User's Feedback
Answer / bsgsr
stored procedure transformation can be used to create and
drop indexes before and after loading into the target.
| Is This Answer Correct ? | 16 Yes | 1 No |
Answer / kalyan
use the post session SQL to craete indexes on the target
table..
| Is This Answer Correct ? | 11 Yes | 1 No |
Why do you use Mapping Parameter and mapping variable?
Can we create out put ports in source qualifier t/r?
What could be the possible resons of locks by user?
What is souce qualifier transformation it is active or passive
What are the types of lookup?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
Which is costliest transformation? costly means occupying more memory?
In real time scenario where can we use mapping parameters and variables?
In a table, 4 person having same salary. How to get Third person record only?
hw cn v elimate dublicate values from lookup without overriding sql?
What are the new features of the server manager in the informatica 5.0?
what is the use of Data Mart?