Informatica Powercenter

123456789101112131415161718192021222324
Across
  1. 2. Stored procedure is a/an _________ transformation (Write either Activee or Passive).
  2. 7. The ______ ______ converts the source data to a standard format used internally by PowerCenter (Write without any space)
  3. 10. Within a repository, objects are organized in ________.
  4. 12. A ________ contains transformations and may be embedded into a Mapping.
  5. 13. ________ transformation will not remove any duplicate records while joining Hetro or Homogenous sources.
  6. 15. Provides current datetime on the PowerCenter Server machine
  7. 17. Session Tasks: Run a Single Mapping (Write Truee/False)
  8. 18. One row comes in, one row goes out – one-for-one input to output called as ___________ transformation (Write either Activee or Passive).
  9. 19. Three types of transformation views: Iconized, Normal and ______
  10. 20. Tool where you create Mappings, Sources, Target.
  11. 23. Generates unique keys for any port on a row .
Down
  1. 1. Sends rows to different destinations based on filter conditions
  2. 3. The Designer tool for creating source definitions.(Write without any space)
  3. 4. Performs heterogeneous/homogeneous joins on only two data flows
  4. 5. Two types of Data types in Informatica PowerCenter (IPC). _______ and Transformation data type.
  5. 6. Passes rows conditionally
  6. 8. The ____________ is the PowerCenter application that enables designers to build and run workflows (Write without any space)
  7. 9. Sum,Max,Min funcations are used in ___________ transformation.
  8. 11. tags rows for insert, update, delete, reject. (Write without any space)
  9. 14. Returns values from a database table or flat file associated with a given input value.
  10. 15. Run the logic of a mapping
  11. 16. performs row-level calculations
  12. 21. An _________ lookup can improve performance because it is only called when the lookup condition is satisfied.
  13. 22. Two types of cache in Lookup, Dynamic cache and _________ cache.
  14. 24. 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.