if you have a session named 's_m_employee_detail' then workflow for the same can be named as '___'.
1.wkf_s_m_employee_detail
2.s_m_employee_detail_wkf_
3. s_m_employee_detail.wkf_
4. All of the above
Posted Date:-2021-11-18 06:57:06
Informatica is a software development company founded in ...............
1. 1990
2.1991
3.1992
4.1993
Posted Date:-2021-11-18 08:03:33
Integration service is the ___ for the Informatica.
1. executing engine
2. ETL Tool
3. SOA
4.None of the above
Posted Date:-2021-11-18 06:50:57
What are the two types of Repositories in INFORMATICA?
1.Global Repositories
2.Local Repositories
3.National Repositories
4. Both A & B
Posted Date:-2021-11-18 10:31:59
What does an informatica variable contains?
1. startvalue/end value
2.start value/current value
3.start value/dynamic value
4.start value/persistent value
Posted Date:-2021-11-18 10:23:15
What is the full form of OLAP?
1.On-Line Analytical Processing
2.On-Line Analysis Processing
3.On-Line Access Processing
4. On-Line Application processing
Posted Date:-2021-11-18 06:54:07
What is the purpose of SQL override?
1. It is used to write user defined SQL statements in source qualifier and look up transformations.
2.Write to cache files
3.Performance tuning
4.None of the above
Posted Date:-2021-11-18 10:24:41
Which of the following client component can be used for creating Repository?
1.Designer
2.Workflow Manager
3.Repository Manager
4.Repository Server Administration Console
Posted Date:-2021-11-18 10:22:44
Which of the following is not an ETL tool?
1.Datastage
2.Informatica
3.Visual studio
4.DT/studio.
Posted Date:-2021-11-18 06:47:49
Which of the following server governs the implementation of various processes among the factors of server’s database repository.
1.Temp server
2.Repository server
3.Domain server
4. Powerhouse server
Posted Date:-2021-11-18 06:51:40
Which of the following transformation is used to combine data from different sources?
1.Union Transformation
2.Joiner transformation
3.Joiner transformation
4.Expression transformation
Posted Date:-2021-11-18 07:54:22
Which of the following transformation is used to convert the rows in to columns?
1.Filter Transformation
2. Source Qualifier
3.Normalizer Transformation
4.Router Transformation
Posted Date:-2021-11-18 10:26:43
Which of the following transformation is used to handle cobol sources?
1.Filter Transformation
2.Source Qualifier
3. Normalizer Transformation
4.Expression Transformation
Posted Date:-2021-11-18 06:54:50
Which of the following transformation is used to handle cobol sources?
1. Source Qualifier
2.Normalizer Transformation
3.Filter Transformation
4.Expression Transformation
Posted Date:-2021-11-18 07:55:07
Which of the following Transformation is used to load the rejected records?
1.Source Qualifier
2.Router Transformation
3.Filter Transformation
4.None of the above
Posted Date:-2021-11-18 10:27:27
Which process is used for online analytical processing?
1.Data
2.Database
3.Data mart
4.Data warehouse
Posted Date:-2021-11-18 07:59:55
............... test is used in an online transactional processing environment.
1.ACID
2.MEGA
3.MICRO
4.MACRO
Posted Date:-2021-11-18 10:22:01
A partition executes in a________.
1. single reader, or writer thread
2.multiple reader, transformation, or writer thread
3.single reader, transformation, or writer thread
4.single reader, multiple transformation, or multiple writer thread
Posted Date:-2021-11-18 06:49:13
Different Components of PowerCenter?
1. Repository Service
2.PowerCenter Clients
3.PowerCenter Service
4.All of the above
Posted Date:-2021-11-18 07:55:54
Flatfile cannot be used for
1. Aggregator
2.Source
3.Lookup
4.Target
Posted Date:-2021-11-18 07:53:40
OLAP stands for______
1.On-Line Access Processing
2.On-Line Analysis Processing
3.On-Line Analytical Processing
4.On-Line Application processing
Posted Date:-2021-11-18 06:42:48
Parameters are created in which tool?
1.Designer
2.Workflow monitor
3.Repository manager
4.Admin console
Posted Date:-2021-11-18 06:59:28
Reusable component in Informatica are:
1. Session
2.Workflow
3.Mapplet
4.Mapping
Posted Date:-2021-11-18 06:41:57
The repository server create and update the repository tables through
1.Native drivers
2. LAN Drivers
3.PSTN Lines
4.Repository agent process
Posted Date:-2021-11-18 10:25:51
Two types of Repositories in Informatica are:
1. Local Repositories
2.Global Repositories
3.National Repositories
4.Both A & B
Posted Date:-2021-11-18 06:44:25
Type of relationship in star schema is______
1. one-to-one.
2.one-to-many.
3.many-to-one.
4.many-to-many.
Posted Date:-2021-11-18 07:03:39
What are the services & components of the Informatica ETL tool?
1. Informatica Designer
2.Workflow Monitor
3. Repository Manager
4. All of the above
Posted Date:-2021-11-18 06:50:03
What ETL Stands for_____
1. Extract, Transform, Load
2.Extreme, Transform, Load
3.Enable, Transactions, Load
4.None of the above
Posted Date:-2021-11-18 06:45:09
What is the function of SCD (Slowly Changing Dimension)?
1.manage data
2.manage workflow
3.manage session
4. None of the above
Posted Date:-2021-11-18 10:28:06
Which Component gets metadata from Repository?
1. Informatica Server
2.Informatica Designer
3.Informatica Workflow Designer
4.Informatica Repository service
Posted Date:-2021-11-18 08:01:44
Which of the following cashes used in informatica?
1. Static
2.Dynamic
3.dynamic,static
4.Dynamic,Static,persistent
Posted Date:-2021-11-18 07:01:44
Which of the following component of informatica is used to see the performance of the workflow while running?
1.Mapping Designer
2. Workflow Monitor
3.Worklet Designer
4.Workflow Manager
Posted Date:-2021-11-18 10:29:50
Which of the following Function(s) cannot be used in Expression Widget?
1. AVG
2.TRIM
3.LTRIM
4.RTRIM
Posted Date:-2021-11-18 08:04:08
Which of the following option is need to be checked for creating shortcuts for folders?
1. Shortcuts
2.Create Shortcuts
3.Allow shortcut
4.None of the above
Posted Date:-2021-11-18 06:55:45
Which of the following session property enabled when update strategy is used in a mapping?
1.DD_UPDATE
2.DD_INSERT
3. Data Driven
4.DD_REJECT
Posted Date:-2021-11-18 07:58:43
Which of the following transformation is not using to connect more than one table?
1.joiner
2.source qualifier
3.lookup
4. sorter
Posted Date:-2021-11-18 08:00:39
Which of the following transformation is used to combine data from different sources?
1.Lookup transformation
2.Joiner transformation
3.Union Transformation
4.Expression transformation
Posted Date:-2021-11-18 06:53:04
Which of the following types of sources are available in informatica?
1.Flatfiles
2.Cobol and XML sources
3.Homogeneous & Heterogeneous
4.All of the above
Posted Date:-2021-11-18 10:29:01
Which one is not an active transformation?
1.Store Procedure
2.Sequence generator
3.SQL
4.Normalizer
Posted Date:-2021-11-18 08:02:57
Which one is not correct about filter transformation?
1. Passes multiple conditions
2.Can't passes multiple conditions
3.Act like 'Case' in pl/sql
4.Act as a 'where' condition
Posted Date:-2021-11-18 06:41:23
Which one is reusable component in Informatica?
1. Mapping
2.Mapplet
3. Session
4. Workflow
Posted Date:-2021-11-18 07:57:24
Which schema is a good alternative to the star schema.
1. Star schema.
2.Fact constellation.
3.Snowflake schema.
4.Star-snowflake schema.
Posted Date:-2021-11-18 07:02:57
Which task is used anywhere in the workflow to run the shell commands?
1. Session Task
2.email Task
3.Command Task
4.Standalone Command Task
Posted Date:-2021-11-18 07:59:22
___ are objects which can be referenced throughout the mapping run (to access their values) and their values can be reassigned.
1.Mapping variables
2.Mapping Parameters
3. Mapping designer
4.All of the above
Posted Date:-2021-11-18 06:56:27