Informatica PowerCenter

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