Informatica PowerCenter

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