How will you check the bottle necks in informatica? From
where do you start checking?

Answer Posted / sanat pandey

Source throught,
Target throught,
Informatica server Idle percentage (in last in session log)
Database (Source / Target)
Network idssue ..

Regards,
Sanat Pandey

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

620


Mention few advantages of router transformation over filter transformation.

633


What is the fact table?

584


Implementation methodology

1255


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

780






can you please explain me pre session and post session options?

6357


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6397


What is fact table? Explain the different kinds of facts.

610


Name the different lookup cache(s)?

699


What are the different components of powercenter?

578


What is the different lookup cache(s)?

608


Different sorts of metadata that stores in the storage facility?

551


Under which circumstances, informatica server creates reject files?

589


How does the aggregator transformation handle null values?

695


Parameter and variable differences

1613