Tag: databases

Questions Related to databases

Which of the following task can be made reusable?

technology databases

  1. Session

  2. Command

  3. Email

  4. All of the above

Show answer
Correct Option: D

Which of the following port is used only in unconnected look up not in connected look up?

technology databases

  1. Input

  2. Variable

  3. Return

  4. Output

Show answer
Correct Option: C

We can use the joiner in case of?

technology databases

  1. Joining two flat files

  2. To join two table from different data bases

  3. To join flat file and relational table

  4. All of the above

Show answer
Correct Option: D

In which of the transformation we can discard duplicate data?
technology databases

  1. Source qualifier, Sorter

  2. Sorter, Joiner

  3. Joiner, Expression

  4. All of the above

Show answer
Correct Option: A

Which is not true regarding unconnected lookup?

technology databases

  1. It does not contain return port

  2. Executed for ever record passed

  3. Works only when lookup function is called

  4. All of above

Show answer
Correct Option: C

AI Explanation

To answer this question, we need to understand the concept of an unconnected lookup.

An unconnected lookup is a type of lookup transformation in Informatica PowerCenter that is not directly connected to a source or target. It is used to perform lookups on a small set of data or to perform complex lookups that cannot be achieved using connected lookups.

Let's go through each option to understand why it is correct or incorrect:

Option A) It does not contain a return port - This option is incorrect. An unconnected lookup does contain a return port. The return port is used to return the result of the lookup operation to the calling transformation or expression.

Option B) Executed for every record passed - This option is incorrect. An unconnected lookup is executed for each record passed to it. It performs a lookup operation for each input record individually.

Option C) Works only when the lookup function is called - This option is correct. An unconnected lookup is not automatically triggered like a connected lookup. It needs to be explicitly called using the LKP expression or LKP transformation in Informatica PowerCenter.

Option D) All of the above - This option is incorrect. Option C is the correct answer, so not all of the options are true.

The correct answer is C) Works only when the lookup function is called. This option is correct because an unconnected lookup is not automatically triggered and needs to be explicitly called using the LKP expression or LKP transformation.

Therefore, the correct answer is C)

What does a power center domain require,at a minimum?

technology databases

  1. Repository Service and Repository Database

  2. Repository Service and Administraive Console

  3. Repository Service and Client Application

  4. Repository Service and Integration Services.

Show answer
Correct Option: A

Why is it best to use shortcuts to a common directory for source and target definition objects?
technology databases

  1. Enforces single –name standard for Sources and Targets.

  2. Shortcuts work more efficiently with databases.

  3. Developers should never create Source and Targets objects on their own.

  4. Makes migration easier and more efficient.

Show answer
Correct Option: D

Null value in SQL represent?
technology databases

  1. An empty String

  2. Zero

  3. NULL is the value used to represent an unknown piece of data

  4. Numeric

Show answer
Correct Option: C

A employee table contain below values empno empname deptno salary 1 aaa 10 30000 2 bbb 20 25000 3 ccc 10 Null 4 ddd Null 35000 select count(deptno) from employee?

technology databases

  1. 1

  2. 3

  3. 2

  4. 4

Show answer
Correct Option: B

A employee table contain below values empno empname deptno salary 1 aaa 10 30000 2 bbb 20 25000 3 ccc 10 Null 4 ddd Null 35000 Select avg(salary) from employee?
technology databases

  1. 0

  2. 30000

  3. 22500

  4. 35000

Show answer
Correct Option: B