Informatica PowerCenter

7. Performs heterogeneous/homogeneous joins on only two data flows
11. The ______ ______ converts the source data to a standard format used internally by PowerCenter (Write without any space)
12. Session Tasks: Run a Single Mapping (Write Truee/False)
13. The Designer tool for creating source definitions.(Write without any space)
17. One row comes in, one row goes out – one-for-one input to output called as ___________ transformation (Write either Activee or Passive).
19. A ________ contains transformations and may be embedded into a Mapping.
21. Provides current datetime on the PowerCenter Server machine
22. The ____________ is the PowerCenter application that enables designers to build and run workflows (Write without any space)
23. 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.
24. performs row-level calculations
25. Two types of Data types in Informatica PowerCenter (IPC). _______ and Transformation data type.

1. Sum,Max,Min funcations are used in ___________ transformation.
2. tags rows for insert, update, delete, reject. (Write without any space)
3. Generates unique keys for any port on a row .
4. Within a repository, objects are organized in ________.
5. ________ transformation will not remove any duplicate records while joining Hetro or Homogenous sources.
6. Returns values from a database table or flat file associated with a given input value.
8. Sends rows to different destinations based on filter conditions
9. Three types of transformation views: Iconized, Normal and ______
10. Passes rows conditionally
14. Tool where you create Mappings, Sources, Target.
15. Which command line tool would you use to execute a workflow?
16. Run the logic of a mapping
18. An _________ lookup can improve performance because it is only called when the lookup condition is satisfied.
20. Two types of cache in Lookup, Dynamic cache and _________ cache.