• platforms and products Online Quiz - 84
Back
0

platforms and products Online Quiz - 84

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

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

technology platforms and products

  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.

Show answer
Correct Option: A

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

technology platforms and products

  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.

Show answer
Correct Option: D

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

technology platforms and products

  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.

Show answer
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.

technology platforms and products

  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.

Show answer
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_____________

technology platforms and products

  1. COBOL Sources

  2. XML Sources

  3. Salesforce.com Sources

  4. Relational DB Sources

Show answer
Correct Option: C

ETL has following components

technology platforms and products

  1. Designer

  2. Workflow Manager

  3. Workflow Monitor

  4. All of above

Show answer
Correct Option: D

In OLAP db we find
technology platforms and products

  1. Staging tables

  2. Dimension Tables

  3. Fact Tables

  4. All of above

Show answer
Correct Option: D

Where do you create Informatica Mappings

technology platforms and products

  1. Designer

  2. Workflow Manager

  3. Workflow Monitor

  4. Source Analyser

Show answer
Correct Option: A

What is the use of DAC

technology platforms and products

  1. Schedule ETL,

  2. Change Capture

  3. Incremental/Full Load

  4. All of above

Show answer
Correct Option: D

What is star Schema

technology platforms and products

  1. Dimension is surrounded by Facts

  2. Fact is surrounded by Dimensions

  3. Dimension is surrounded by Dimensions

  4. All of above

Show answer
Correct Option: B

What is DAC

technology platforms and products

  1. Data warehouse Admin Tool

  2. Data Administration Console

  3. Database Administration Console

  4. Data warehouse Administration Console

Show answer
Correct Option: D

Below are types of graph can be generated from Analytics -

technology platforms and products

  1. pivot

  2. pie

  3. radar

  4. bubble

Show answer
Correct Option: A,B,C,D

Delivers deliver information to -

technology platforms and products

  1. email

  2. handheld

  3. wireless device

  4. all of above

Show answer
Correct Option: D

LDAP authentication refers to -

technology platforms and products

  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

Show answer
Correct Option: B,D

SIL loads data into

technology platforms and products

  1. Staging OLAP

  2. Target OLAP

  3. Target OLAP

  4. None of above

Show answer
Correct Option: B

What is scheduler in analytics?

technology platforms and products

  1. runs analytics server

  2. runs analytics web server

  3. used for chart types of reports

  4. none of above

Show answer
Correct Option: D

Answers is -

technology platforms and products

  1. place to create report request

  2. to see dashboard results

  3. shows list of subject areas

  4. all of above

Show answer
Correct Option: A,B

Report data can be downloaded in following formats:

technology platforms and products

  1. pdf

  2. excel

  3. html

  4. text

Show answer
Correct Option: A,B,C

Which one is default view of report results?

technology platforms and products

  1. pivot

  2. tabular

  3. chart

  4. header

Show answer
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:

technology platforms and products

  1. is equal to/is in

  2. is needed

  3. is not equal to/is not in

  4. is prompted

Show answer
Correct Option: D
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions