IPC-Pjoshi

2. Returns values from a database table or flat file associated with a given input value.
3. One row comes in, one row goes out – one-for-one input to output called as ___________ transformation (Write either Activee or Passive).
5. Which command line tool would you use to execute a workflow?
10. Run the logic of a mapping
11. Two types of Data types in Informatica PowerCenter (IPC). _______ and Transformation data type.
14. Provides current datetime on the PowerCenter Server machine
15. tags rows for insert, update, delete, reject. (Write without any space)
16. Two types of cache in Lookup, Dynamic cache and _________ cache.
17. An _________ lookup can improve performance because it is only called when the lookup condition is satisfied.
19. Performs heterogeneous/homogeneous joins on only two data flows
20. The ______ ______ converts the source data to a standard format used internally by PowerCenter (Write without any space)
21. The Designer tool for creating source definitions.(Write without any space)
22. The ____________ is the PowerCenter application that enables designers to build and run workflows (Write without any space)

1. A ________ contains transformations and may be embedded into a Mapping.
4. Sum,Max,Min funcations are used in ___________ transformation.
6. 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.
7. performs row-level calculations
8. Generates unique keys for any port on a row .
9. Passes rows conditionally
12. Three types of transformation views: Iconized, Normal and ______
13. Tool where you create Mappings, Sources, Target.
15. ________ transformation will not remove any duplicate records while joining Hetrogenous or Homogenous sources.
18. Session Tasks: Run a Single Mapping (Write Truee/False)
23. Sends rows to different destinations based on filter conditions
24. Within a repository, objects are organized in ________.