Informatica PowerCenter

4. Sends rows to different destinations based on filter conditions
6. Two types of cache in Lookup, Dynamic cache and _________ cache.
9. Provides current datetime on the PowerCenter Server machine
10. Returns values from a database table or flat file associated with a given input value.
11. Generates unique keys for any port on a row .
14. Two types of Data types in Informatica PowerCenter (IPC). _______ and Transformation data type.
15. One row comes in, one row goes out – one-for-one input to output called as ___________ transformation (Write either Activee or Passive).
16. Performs heterogeneous/homogeneous joins on only two data flows
17. 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.
19. The ____________ is the PowerCenter application that enables designers to build and run workflows (Write without any space)
20. Session Tasks: Run a Single Mapping (Write Truee/False)
21. ________ transformation will not remove any duplicate records while joining Hetro or Homogenous sources.
24. The Designer tool for creating source definitions.(Write without any space)
25. Passes rows conditionally

1. Three types of transformation views: Iconized, Normal and ______
2. Tool where you create Mappings, Sources, Target.
3. A ________ contains transformations and may be embedded into a Mapping.
5. tags rows for insert, update, delete, reject. (Write without any space)
7. Sum,Max,Min funcations are used in ___________ transformation.
8. The ______ ______ converts the source data to a standard format used internally by PowerCenter (Write without any space)
12. performs row-level calculations
13. An _________ lookup can improve performance because it is only called when the lookup condition is satisfied.
18. Which command line tool would you use to execute a workflow?
22. Run the logic of a mapping
23. Within a repository, objects are organized in ________.