Informatica Expert Quiz

Posted on: | By: – Comments Off

Informatica Quiz

Informatica Quiz : This Informatica Expert Quiz contains set of 60 Informatica Quiz which will help to clear any exam which is designed for Expert.



1) Which of the following is a Web Based application for administering the powercenter domain and powercenter security

  1. Repository Manager
  2. ans)Admin console
  3. repository service
  4. integration service

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
2) which is not the valid kind on lock on repository objects

  1. Read lock
  2. write lock
  3. execute lock
  4. Exclusive lock

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
3) the extension of a repository backup file is

  1. .REP
  2. .BAK
  3. .DBF
  4. any extension can be given

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
4) Which components are required to run a debug session?

  1. The Designer
  2. The Designer and the Workflow Manager
  3. The Designer and a running Informatica server
  4. The Designer, the Workflow Manager, and a running Informatica server

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
5) What type of debugger sessions can be configured?

  1. Use an existing non-reusable session
  2. Use an existing reusable session
  3. Create a debug session instance
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
6) A scheduling tool from BMC software

  1. CONTROL M
  2. Autosys
  3. workflow scheduler
  4. Maestro

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
7) Which is not a Type of Pushdown optimization:

  1. Source side Pushdown optimization
  2. Target side Pushdown optimization
  3. Full Pushdown optimization
  4. Transformation Pushdown optimization

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : d[/bg_collapse]
 
 
8) For  pushdown optimization the integration service creates  which DML in case of source side pushdown?

  1. insert statement
  2. Select insert statement
  3. Select statement
  4. Update,insert,Delete statement

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : c[/bg_collapse]
 
 
9) What is ‘PowerCenter Pushdown Optimization Option’ in Informatica

  1. Transforms Mapplet logic into SQL Queries and sends to database
  2. Transforms Transformation logic into SQL Queries and sends to database
  3. Transforms Session logic into SQL Queries and sends to database
  4. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
10) Types of Pushdown optimizations

  1. Source-side push down
  2. Target side push down
  3. Full push down
  4. All

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]



 
11) For  pushdown optimization the integration service creates  which DML in case of target side pushdown?

  1. select update statement
  2. Select insert statement
  3. Select statement
  4. Update,insert,Delete statement

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
12) Which statement about integration service is true?

  1. When the Integration Service pushes transformation logic to the database, it cannot track errors that occur in the database
  2. integration service can also track database errors
  3. integration service cannot push transformation logic to the database
  4. all above statements are valid

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
13) To use different pushdown optimization configuration at different times, use the ________________ mapping parameter

  1. $$configpushdown
  2. $$Pushdownconfig
  3. $$pushdownsource
  4. $$pushdowntarget

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
14) In Pushdown Optimization the amount of transformation logic that can be pushed to the database depends on the ___________

  1. database, transformation logic, mapping and session configuration
  2. database, transformation logic and mapping configuration
  3. transformation logic, and mapping configuration
  4. transformation logic, mapping and session configuration

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
15) Pushdown Optimization is used for

  1. Optimizing the session performance while execution
  2. Optimizing the workflow performance while executing
  3. Optimizing the lookup performance
  4. Is a session property to pushdown the transformation logic to the database

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
16) To improve performance, where should a filter transformation be placed?

  1. As early in the mapping as possible.
  2. As late in the mapping as possible.
  3. Immediately before an Aggregator transformation.
  4. Immediately before an Expression transformation.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
17) Which of the below statements helps in improving the performance

  1. indexes need to be enabled before running a session
  2. Drop the constraints and indexes before running the session and rebuild them after completion of session
  3. indexes should be dropped but constraints should be enabled before running a session
  4. disable the constraints but enable the indexes before running a session

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
18) How to improve the session performance in aggregator transformation?

  1. Using Sorted Input
  2. Using Index
  3. Using SQL Override
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
19) How can you minimize the cache for a joiner transformation?

  1. Make the smaller source the master source
  2. Make the smaller source the details source
  3. Sort the master data prior to the joiner transformation
  4. sort the detail data prior to the joiner transformation

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
20) When you want to create an additional pipeline stage to improve performance, but do not want to change the distribution of data across partitions, use _______ partition

  1. Database
  2. Key range
  3. Hash user keys
  4. Pass-through

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]



 
21) Which of the following is True on Load Balancing?

  1. Load Balancer dispatches tasks from the dispatch queue based on the service levels
  2. When multiple tasks are waiting to be dispatched, the Load Balancer dispatches high priority tasks before low priority tasks
  3. You can create service levels and configure the dispatch priorities
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
22) Integration Service processes the transformation logic if which of the following conditions are true:

  1. The transformation logic updates a mapping variable and saves it to the repository database
  2. The transformation contains a variable port.
  3. The session is not configured to override the default values of input or output ports.
  4. a&b

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : d[/bg_collapse]
 
 
23) Which of the following criteria affects whether the Integration Service can push the transformation to the database?

  1. Type of transformation
  2. Location of the transformation in the mapping
  3. Mapping and session configuration for the transformation
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : d[/bg_collapse]
 
 
24) Pushdown optimization viewer shows.

  1. ETL logic
  2. Transformation details
  3. SQL queries or messages related to the pushdown
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
25) Pushdown optimization cannot be used on which transformation?

  1. Source Qualifier
  2. Target
  3. Rank
  4. Union

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
26) When can you say that there is a source bottleneck?

  1. When the Integration Service spends more time on the reader thread than the transformation or writer threads
  2. When the Integration Service spends more time on the transformation thread than the reader or writer threads
  3. When the Integration Service spends more time on the writer thread than the transformation or reader threads
  4. All above statements create source bottleneck

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
27) You are optimizing a mapping. Which of the following statements about expressions is true?

  1. String operations are faster than number operations
  2. You should trim char and varchar fields before performing comparisons.
  3. ans)The CONCAT function is faster than the || operator
  4. Using a variable is less efficient than using the equivalent code in several expressions.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
28) Which statement about optimizing Mapping bottleneck are valid?

  1. Configure for Single-Pass reading
  2. Avoid unnecessary datatype conversions
  3. Avoid database reject errors
  4. All the above statements are valid

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
29) The______ratio indicates the number of read or write operations the Integration Service performs on the cache.
 

  1. hit ratio
  2. miss ratio
  3. a&b
  4. None of the Above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
30) [(# of reads from disk) + (# of writes to disk)]/[(# of reads from memory cache) + (# of writes to memory cache)] is the formula for

  1. hit ratio
  2. miss ratio
  3. a&b
  4. None of the Above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]



 
31) Which is not valid for optimizing system bottleneck?

  1. Improve network speed
  2. improve CPU performance
  3. increase paging
  4. check hard disks on related machines

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
32) ___________is a PowerCenter web application to browse,analyze and manage metadata form disparate sources

  1. informatica IDQ
  2. informatica powerexchange
  3. informatica Metadata Manager
  4. Informatica MDM

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
33) ________ is used to analyze where data originates, how the data is transformed and what objects transform it, and where the data ends

  1. impact Analysis
  2. Data Lineage
  3. data depenedency
  4. data quality

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
34) which repository table stores the name of each PowerCenter repository folder

  1. OPB_MAPPING
  2. OPB_TASK
  3. OPB_FOLDER
  4. OPB_SUBJECT

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
35) The repository table thast stores the names and IDs of all the transformation fields for each of the transformations

  1. OPB_MAPPING
  2. OPB_TASK
  3. OPB_WIDGET_FIELD
  4. OPB_COLUMNS

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
36) The repository table which stores the component details like Post-Session-Success-Email, commands in Post-Session/pre-Session etc

  1. OPB_COMPONENT
  2. OPB_SESSIONS
  3. OPB_TASK_ATTR
  4. OPB_REPO

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
37) Which repository table stores information regarding repository name and its associated domain

  1. OPB_REPOSIT
  2. OPB_SESSIONS
  3. OPB_TASK_ATTR
  4. OPB_REPO

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
38) This table stores the details of the expressions used anywhere in PowerCenter

  1. OPB_MAPPING
  2. OPB_TASK
  3. OPB_EXPRESSION
  4. OPB_DETAILS

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
39) The repository table that stores the name and ID of each mapping and its corresponding folder

  1. OPB_MAPPING
  2. OPB_TASK
  3. OPB_EXPRESSION
  4. OPB_DETAILS

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
40) Which plug in enables IT to access and extract data from social media networks and integrate data in batch or real time

  1. PowerExchange for Social Media
  2. PowerExchange
  3. No plug in is required
  4. Powerexchange for twitter

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]



 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz