Tag: databases

Questions Related to databases

All reports should be created using the Oracle Server connections?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

we can create report using more than one database?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

how many sub reports we can create for one main report ?
technology databases

  1. 1

  2. 256

  3. unlimited

  4. 512

Show answer
Correct Option: B

Which of the following transformations cannot immediately precede Joiner transformation?
technology databases

  1. Source Qualifier

  2. Sequence Generator

  3. External Procedure

  4. Update Strategy

Show answer
Correct Option: B,D

Which of the following can be used in an Update Strategy transformation?
technology databases

  1. DD_INSERT

  2. DD_UPDATE

  3. DD_DELETE

  4. DD_TRUNCATE

Show answer
Correct Option: A,B,C

In an expression transformation, a port can be an output as well as variable port.
technology databases

  1. variable port

  2. Output port

  3. Both a & b

  4. Only a

Show answer
Correct Option: C

Which transformation converts the native datatypes to Informatica datatypes for the source.
technology databases

  1. Stored Procedure

  2. Source Qualifier

  3. Expression

  4. Normalizer

  5. Joiner

Show answer
Correct Option: B

Default caching mechanism for lookup transformation.
technology databases

  1. static

  2. persistent

  3. dynamic

  4. shared

Show answer
Correct Option: C

Which of the following transformation allows you to define database table over a flat file.
technology databases

  1. Source Table

  2. External Tables

  3. Source Qualifier

  4. Table Function

Show answer
Correct Option: B

Which transformation processes on row-by-row basis.
technology databases

  1. AGGREAGATOR

  2. FILTER

  3. EXPRESSION

  4. SEQUENCE GENERATOR

Show answer
Correct Option: C