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

Show Answer

 
 
2) which is not the valid kind on lock on repository objects

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

Show Answer

 
 
3) the extension of a repository backup file is

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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
6) A scheduling tool from BMC software

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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
10) Types of Pushdown optimizations

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

Show Answer

 
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

Show Answer

 
 
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

Show Answer

 
 
13) To use different pushdown optimization configuration at different times, use the ________________ mapping parameter

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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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.

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
25) Pushdown optimization cannot be used on which transformation?

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

Show Answer

 
 
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

Show Answer

 
 
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.

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
34) which repository table stores the name of each PowerCenter repository folder

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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer