If I have a index defined on target table and if set it to
bulk load will it work ?
Answer Posted / parikhita prusty
Bulk load never support the index.so if index in target with
bulk load the session will fail.so before use bulk load u
have to drop index in target,Normal load supports index.
| Is This Answer Correct ? | 21 Yes | 0 No |
Post New Answer View All Answers
How many types of sessions are there in informatica.please explain them?
What is the use of an aggregator cache file?
Define mapplet?
which one is better performance wise joiner or look up
How to load the data from a flat file into the target where the source flat file name changes daily?
Design time, run time. If you don't create parameter what will happen
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is incremental aggregation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
what is unit testing?tell me proceedure
Explain what is informatica metadata and where is it stored?
What do you understand by term role-playing dimension?
How can we use mapping variables in informatica? Where do we use them?
Why update strategy and union transformations are active?
What is an expression transformation in informatica?