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 / sony_infa

use session partition to improve the performance.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the maplet?

616


Implementation methodology

1255


How to extract sap data using informatica? What is abap? What are idocs?

550


How an expression transformation differs from aggregator transformation?

622


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

553






I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1312


Name the different lookup cache(s)?

699


Does an informatica transformation support only aggregate expressions?

602


What is transformation?

655


without table how to come first record only in oracle?

1845


How to load the data from a flat file into the target where the source flat file name changes daily?

572


Repository user profiles

1373


How to do the error handling of if ur source is flatfiles?

1504


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1864


What is source qualifier transformation in informatica?

569