Tag: databases

Questions Related to databases

What does Source Definitions stands for in terms of ETL processes?

technology databases

  1. Tranform

  2. Extract

  3. Load

  4. All of the Above

Show answer
Correct Option: B

What does a node refers to in terms of ETL concepts?

technology databases

  1. Physical machines on which PowerCenter services are installed

  2. Logical ETL environment

  3. ETL and metadata services

  4. House keeping the ETL environment

Show answer
Correct Option: A

Which of the following is a mandatory mapping component

technology databases

  1. Mapplets

  2. Sessions

  3. Transformations

  4. Workflows

Show answer
Correct Option: C

A source can be modified from Mapping designer

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which of the following is not a part of Designer Interface
technology databases

  1. Source Analyzer

  2. Target Designer

  3. Workflow Monitor

  4. Mapplet Designer

Show answer
Correct Option: C

Which of the following interfaces can be used to create a Transformation
technology databases

  1. Transformation Developer

  2. Source Analyzer

  3. Target Designer

  4. Mapping Designer

Show answer
Correct Option: A,D

Transformation Developer is used only for creating reusable transformations
technology databases

  1. True

  2. False

Show answer
Correct Option: A

A mapplet is a combination of reusable mappings

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which of the following can be modified in Source Analyzer
technology databases

  1. Source/Table Name

  2. Database Name

  3. Source/Table Structure

  4. All of the above

Show answer
Correct Option: D

How can a source defination created in Informatica?
technology databases

  1. Import from database

  2. By draging a target defination

  3. By using create option in Sources tag

  4. All of the above

Show answer
Correct Option: A,C