Web Design and Informatica PowerCenter Technology

Covers web page structures, browsers, and hypertext links, as well as Informatica PowerCenter ETL concepts including mappings, transformations, and database operations.

20 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

which is true about folder privileges

  1. a. copy privilege enables the user to copy folders within the same repository alone.
  2. b. Copy privilege enables the user to read and write on folders
  3. c. Manage versions privilege enable the user to read and write on folders
  4. d.Mange versions privilege enable the user to read on folders
Question 2 Multiple Choice (Single Answer)

which of the following can not be used in mapplet

  1. a.source definitions
  2. b. Normalizer transformations
  3. c.custome transformation
  4. d.stored procedure transformation
Question 3 True/False

when you run a session from a workflow ,you can run an another sessions in the same workflow before the first session completed.

  1. True
  2. False
Question 4 Multiple Choice (Multiple Answers)

which is true about mapping parameter and variables

  1. a.A mapping parameter and the variables retains the same value throughout the entire session.
  2. b.a mapping variable represents a value that can change through the session.
  3. c.You can create mapping parameters and variables in the Mapping Designer or Mapplet Designer.
  4. d. None of the above
Question 5 Multiple Choice (Single Answer)

which is false about target definition

  1. a. targets are created in target analyser
  2. b.target can be created from the source just dragging the source into target analyser.
  3. c.target can be created from a expression transformation
  4. d.none of the above.
Question 6 Multiple Choice (Multiple Answers)

which is true ( Choose all that apply)

  1. a.An object is checked out by default when you create, copy, replace, or import it.
  2. b. No other users can edit the object when you have it checked out
  3. c. check out is not needed to edit an object
  4. d. None of the above
Question 7 True/False

The session property on the indexed table can be set to bulk insert mode.

  1. True
  2. False
Question 8 True/False

If you configure a Lookup transformation to use a dynamic cache, you can use only the equality operator (=) in the lookup condition

  1. True
  2. False
Question 9 Multiple Choice (Single Answer)

Unconnected lookup uses

  1. a. Static or Dynamic Cache
  2. b. Dynamic cache
  3. c. static cache
  4. d. Static and Dynamic Cache
Question 10 Multiple Choice (Single Answer)

which of the following is false about source qualifier

  1. a. Filter rows when the Integration Service reads source data.
  2. b. Join data originating from the same source database
  3. c. Can specify a target load order based on the Source Qualifier transformations in a mapping
  4. d. Create a custom query to issue a special SELECT statement for the Integration Service to read source data.
Question 11 Multiple Choice (Single Answer)

Which Table contain the values that explain the type of transactions made for a Booking in BookingHistory Application?

  1. CategoryTypes
  2. ActivityCodes
  3. ActivityTypes
  4. CategoryCodes
Question 12 Multiple Choice (Single Answer)

Port Code is a table of what type?

  1. Static(Fixed Table)
  2. Static(Updated by Domain Drain)
  3. Dynamic(Updated by Domain Drain)
  4. Dynamic(Manual Addition)
Question 13 Multiple Choice (Single Answer)

Which table gives the type of Application-Independent,Dependent?

  1. AppGoTo
  2. AppGroupCode
  3. Applist
  4. Standalone
Question 14 True/False

We need not grant permissions for executing Stored Procedures in Database(From Standards Point of view)?

  1. True
  2. False
Question 15 Multiple Choice (Single Answer)

Relative path make your hypertext links______.

  1. Portable
  2. Discrete
  3. Uniform
  4. Standard
Question 16 Multiple Choice (Single Answer)

A _____ structure starts with a general topic that includes link to more specific topics.

  1. Hierarchical
  2. Linear
  3. Mixed
  4. Ralative
Question 17 True/False

Because each computer differs in terms of what fonts it can display, each individual browser determines how text is to be displayed.

  1. True
  2. False
Question 18 True/False

You do not have to connect to the internet to verify changes to a Web page on your computer.

  1. True
  2. False
Question 19 True/False

You can combine structures e.g, linear and hierarchical.

  1. True
  2. False
Question 20 True/False

You can combine structures e.g, linear and hierarchical.

  1. True
  2. False