Informatica Powercenter

4. performs row-level calculations
5. Sends rows to different destinations based on filter conditions
8. A ________ contains transformations and may be embedded into a Mapping.
11. Specifies one or more UNIX command or shell script, DOS command or batch file for Integration Services to run during a workflow called as _______ Task.
12. tags rows for insert, update, delete, reject. (Write without any space)
13. ________ transformation will not remove any duplicate records while joining Hetro or Homogenous sources.
15. Two types of cache in Lookup, Dynamic cache and _________ cache.
17. Session Tasks: Run a Single Mapping (Write Truee/False)
18. Stored procedure is a/an _________ transformation (Write either Activee or Passive).
19. An _________ lookup can improve performance because it is only called when the lookup condition is satisfied.
20. Returns values from a database table or flat file associated with a given input value.
21. The Designer tool for creating source definitions.(Write without any space)
22. Sum,Max,Min funcations are used in ___________ transformation.
24. Tool where you create Mappings, Sources, Target.
25. Passes rows conditionally

1. Two types of Data types in Informatica PowerCenter (IPC). _______ and Transformation data type.
2. Within a repository, objects are organized in ________.
3. The ____________ is the PowerCenter application that enables designers to build and run workflows (Write without any space)
6. Provides current datetime on the PowerCenter Server machine
7. Generates unique keys for any port on a row .
9. The ______ ______ converts the source data to a standard format used internally by PowerCenter (Write without any space)
10. One row comes in, one row goes out – one-for-one input to output called as ___________ transformation (Write either Activee or Passive).
14. Run the logic of a mapping
16. Performs heterogeneous/homogeneous joins on only two data flows
23. Three types of transformation views: Iconized, Normal and ______