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


Please Help Members By Posting Answers For Below Questions

What are the mapping parameters and mapping variables?

616


How many ways are there to do 'remove duplicate records in informatica'?

582


What is a filter transformation and why it is an active one?

558


can we override a native sql query within informatica? Where do we do it? How do we do it?

595


what are factless facts? And in which scenario will you use such kinds of fact tables.

1307






What are different types of transformations available in informatica?

580


Under what condition selecting sorted input in aggregator may fail the session?

655


What are the types of schemas we have in data warehouse.

526


Target increases every day even though no new record was inserted

1103


What can we do to improve the performance of informatica aggregator transformation?

610


What does role playing dimension mean?

619


What is intricate mapping?

586


What is Data Caches size?

652


Explain the different dimensions.

548


how tokens will generate?

1728