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
which one is better performance wise joiner or look up
How will the document be delivered to me?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is the difference between informatica 7.0 and 8.0?
How you know when to use a static cache and dynamic cache in lookup transformation?
Explain Dataware house architecture .how data flow from intial to end?
What is a surrogate key?
What is the format of informatica objects in a repository?
What is meant by active and passive transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
What are different types of transformations available in informatica?
draw informatica architecture 8.6 ?
Briefly define a session task?
Explain lookup transformation is active in informatica
What is parallel processing in informatica?