If you want to create indexes after the load process which
transformation you choose?
- 3 Answers
- 19560 Views
- HCL, I also Faced
- E-Mail Answers
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 parallel processing in informatica?
What are different types of transformations available in informatica?
How many types of sessions are there in informatica.please explain them?
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.
What does reusable transformation mean?
What are the different clients of powercenter?
what is song in infrmatica...?
What is main use of mapplet?
How can repository reports be accessed without sql or other transformations?
Explain the aggregator transformation?
Write the advantages of partitioning a session?
what are 3 tech challenges/ common issues you face?
Describe data concatenation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
