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 / venkateshmalneni
if we do the performance optimization we can achieve the task i think (ie we can reduce the time of loading the data into target)
if my answer is wrong please let me know the write answer
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain the informatica workflow?
How can we store previous session logs?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How an expression transformation differs from aggregator transformation?
Explain why we use partitioning the session in informatica?
How to use pmcmd utility command?
What do you mean by worklet?
Explain in detail scd type 2 through mapping.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is dimensional table? Explain the different dimensions.
what is diff b/t sorter t/r and agg have the option sorter property...
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How do you handle two sessions in Informatica
What are the types of caches in lookup?