Informatica PowerCenter

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