How can you validate all mappings in the repository simultaneously?
What is blocking transformation?
can we override a native sql query within informatica? Where do we do it?
Write the advantages of partitioning a session?
Explain the types of transformations?
Explain what transformation and how many are there in informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How can a transformation be made reusable?
What is a repository manager?
How do you load only null records into target? Explain through mapping flow.
What are data-driven sessions?
What do you mean by blocking transformation?
Explain pmcmd command usage in informatica
How you prepared reports for OLAP?
Make a note of the quantity vaults made in informatica?