I cleared Informatica certification Designer. if anybody
need dumps, can contact at mukesh1009@gmail.com
Post New Answer View All Answers
What is the difference between STOP and ABORT options in Workflow Monitor?
can we override a native sql query within informatica? Where do we do it?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
difference between repository database and repository service?
Explain the scenario which compels informatica server to reject files?
What is a repository manager?
How do you change a non-reusable transformation to reusable transformation?
What is repository manager?
What is InformaticaPowerCenter?
What are the different components of powercenter?
How can we improve session performance in aggregator transformation?
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 to differentiate between the active and passive transformations?
Why update strategy and union transformations are active? Explain with examples.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.