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
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Design a mapping to load the cumulative sum of salaries of employees into target table?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are the differences between oltp and olap?
According to his methodology what all you need before you build a datawarehouse
What are the different ways to implement parallel processing in informatica?
Explain the aggregator transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Make a note of the quantity vaults made in informatica?
Enlist few areas or real-time situations where informatica is required.
How to use pmcmd utility command?
How to differentiate between the active and passive transformations?
How you know when to use a static cache and dynamic cache in lookup transformation?
Whats there in global repository
What is meant by target load plan?