Informatica PowerCenter

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