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
Whats there in global repository
What differs when we choose the sorted input for aggregator transformation?
Partition, what happens if the specified key range is shorter and longer
What are the types of schemas we have in data warehouse.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Under which circumstances, informatica server creates reject files?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the new features of informatica 9.x at the developer level?
What is the difference between Active and Passive transformation?
Separate from a database, an information bazaar, and an information stockroom?
What is dimensional table?
How to open an older version of an object in the workspace?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?