if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
Answer Posted / sravanthi
in session level go to the mapping tab set the load type is BULK so it reduce the loading time
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Write the unconnected lookup syntax?
How we can use union transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is dimensional table?
Enterprise data warehouse your projects phase by phase explain?
What is target load order?
What are the differences between joiner transformation and source qualifier transformation?
how we can load rejected record's at run time?(not through bad files)
How can a transformation be made reusable?
How to update source definition?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the scenario which compels informatica server to reject files?
can u any challenge your project?
How can we create index after completion of load process?