0

platforms and products Online Quiz - 84

Description: platforms and products Online Quiz - 84
Number of Questions: 20
Created by:
Tags: platforms and products
Attempted 0/20 Correct 0 Score 0

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

  1. $$$SessStartTime returns the session start time as string and SESSSTARTTIME returns as a date/time.

  2. $$$SessStartTime returns the session start time as an integer and SESSSTARTTIME returns as a date/time.

  3. $$$SessStartTime returns the session start time as string and SESSSTARTTIME returns as an integer.

  4. There is no difference in practice. Either can be used to used to return the Session start time.


Correct Option: A

What type of expressions can be used in an Aggregator transformation variable port?

  1. Aggregate or Non-Aggregate expressions, provided they are not used together in a single variable port.

  2. Aggregate and Non-Aggregate expressions, together in the same variable port.

  3. Aggregate, Non-Aggregate and conditional expressions, together in the same variable port, provided that the variable port is also made a ‘group-by’ port.

  4. Non-Aggregate and conditional expressions only.


Correct Option: D

Which of the following methods is not a valid way to enter the Aggregator transformation cache size?

  1. Use the cache calculator to enter the cache size based on Group by ports.

  2. Choose “Auto”.

  3. Enter the default cache sizes in the mapping properties.

  4. Type a number value in KB, MB or GB.


Correct Option: D

PowerCenter 8. X - One Repository Service can manage only one Repository. 2. PowerCenter 7.X – One Repository Server can manage multiple repositories. Choose the correct option.

  1. Statement 1 is true and Statement 2 is false.

  2. Statement 1 is false and Statement 2 is true.

  3. Both are false.

  4. Both are true.


Correct Option: D

AI Explanation

To answer this question, you need to understand the differences between PowerCenter 8.X and PowerCenter 7.X in terms of managing repositories.

Statement 1: PowerCenter 8.X - One Repository Service can manage only one Repository. Statement 2: PowerCenter 7.X - One Repository Server can manage multiple repositories.

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

Option A) Statement 1 is true and Statement 2 is false. This option is incorrect because both statements are actually true. In PowerCenter 8.X, each Repository Service can manage only one repository. In PowerCenter 7.X, each Repository Server can manage multiple repositories.

Option B) Statement 1 is false and Statement 2 is true. This option is incorrect because both statements are actually true. In PowerCenter 8.X, each Repository Service can manage only one repository. In PowerCenter 7.X, each Repository Server can manage multiple repositories.

Option C) Both are false. This option is incorrect because both statements are actually true. In PowerCenter 8.X, each Repository Service can manage only one repository. In PowerCenter 7.X, each Repository Server can manage multiple repositories.

Option D) Both are true. This option is correct because both statements are true. In PowerCenter 8.X, each Repository Service can manage only one repository. In PowerCenter 7.X, each Repository Server can manage multiple repositories.

Therefore, the correct answer is option D. Both Statement 1 and Statement 2 are true.

Application Source Qualifier is used with_____________

  1. COBOL Sources

  2. XML Sources

  3. Salesforce.com Sources

  4. Relational DB Sources


Correct Option: C
  1. Designer

  2. Workflow Manager

  3. Workflow Monitor

  4. All of above


Correct Option: D

In OLAP db we find

  1. Staging tables

  2. Dimension Tables

  3. Fact Tables

  4. All of above


Correct Option: D

Where do you create Informatica Mappings

  1. Designer

  2. Workflow Manager

  3. Workflow Monitor

  4. Source Analyser


Correct Option: A

What is the use of DAC

  1. Schedule ETL,

  2. Change Capture

  3. Incremental/Full Load

  4. All of above


Correct Option: D

What is star Schema

  1. Dimension is surrounded by Facts

  2. Fact is surrounded by Dimensions

  3. Dimension is surrounded by Dimensions

  4. All of above


Correct Option: B

What is DAC

  1. Data warehouse Admin Tool

  2. Data Administration Console

  3. Database Administration Console

  4. Data warehouse Administration Console


Correct Option: D

Below are types of graph can be generated from Analytics -

  1. pivot

  2. pie

  3. radar

  4. bubble


Correct Option: A,B,C,D

Delivers deliver information to -

  1. email

  2. handheld

  3. wireless device

  4. all of above


Correct Option: D

LDAP authentication refers to -

  1. LDAP will be used to login user in analytics

  2. DB Users to be created to make sure users gets into Analytic

  3. password need to set in repository

  4. No need to create Repository users


Correct Option: B,D

SIL loads data into

  1. Staging OLAP

  2. Target OLAP

  3. Target OLAP

  4. None of above


Correct Option: B

What is scheduler in analytics?

  1. runs analytics server

  2. runs analytics web server

  3. used for chart types of reports

  4. none of above


Correct Option: D

Answers is -

  1. place to create report request

  2. to see dashboard results

  3. shows list of subject areas

  4. all of above


Correct Option: A,B

Report data can be downloaded in following formats:

  1. pdf

  2. excel

  3. html

  4. text


Correct Option: A,B,C

Which one is default view of report results?

  1. pivot

  2. tabular

  3. chart

  4. header


Correct Option: B

What option is to be selected for filter criteria to make sure report data will be filtered as per dashboard prompt values, operator should be:

  1. is equal to/is in

  2. is needed

  3. is not equal to/is not in

  4. is prompted


Correct Option: D
- Hide questions