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
can we override a native sql query within informatica? Where do we do it?
Mention few advantages of router transformation over filter transformation.
What is the fact table?
Implementation methodology
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?
can you please explain me pre session and post session options?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is fact table? Explain the different kinds of facts.
Name the different lookup cache(s)?
What are the different components of powercenter?
What is the different lookup cache(s)?
Different sorts of metadata that stores in the storage facility?
Under which circumstances, informatica server creates reject files?
How does the aggregator transformation handle null values?
Parameter and variable differences