If you want to create indexes after the load process which
transformation you choose?
Answer Posted / 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 |
Post New Answer View All Answers
What is incremental aggregation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Is there any way to read the ms excel datas directly into informatica?
Write the unconnected lookup syntax and how to return more than one column.
Which files are created during the session rums by informatics server?
Is it possible to revert a global repository to local one and why?
What is a transaction control transformation?
How can we update a record in the target table without using update strategy?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is the difference between a connected look up and unconnected lookup?
What are active and passive transformations?
What are the informatica performance improvement tips
Explain the difference between a data warehouse and a data mart?
Explain the informatica workflow?