How to improve the session performance in informatica?

Answer Posted / vinay kumar

set properties of mapping tab set bulk loading option in sesstion then performs is increasng..........but sometimes session is failed, the session is no reusable
tht is an drawback

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does refresh system mean, and what are its distinctive choice?

822


Explain sessions and how many types of sessions are there?

819


Explain load alternative records / rows into multiple targets - informatica

943


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1852


What is decode in static cache?

840


What is session task and command task?

891


What is a repository? And how to add it in an informatica client?

933


How to generate or load values in to the target table based on a column value using informatica etl tool.

868


What are the types of lookup transformation?

881


What is sq transformation?

887


How can we update a record in the target table without using update strategy?

952


Explain the types of lookup transformation?

813


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9497


Tell me about Propagate functions in informatica

740


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1840