Informatica is a Software development company, which offers data integration products. If offers products for ETL, data masking, data Quality, data replica, data virtualisation, master data management, etc.
Informatica is better than its competitors as it offers a wide range of product editions. So the user can opt for a specific edition based upon the requirement. Informatica is constantly featured as Data Integration product leader in the Gartner Magic Quadrant listing.
Below are the answer of the Trend Technology Informatica L1 Mock Test.
Disable Ctrl Key, Right click and F12
Informatica Powercenter ETL/Data Integration tool is a most widely used tool and in the common term when we say Informatica, it refers to the Informatica PowerCenter tool for ETL.
Informatica Powercenter is used for Data integration. It offers the capability to connect & fetch data from different heterogeneous source and processing of data.
Typical use cases for Informatica can be
Informatica Powercenter is used for Data integration. It offers the capability to connect & fetch data from different heterogeneous source and processing of data.
Typical use cases for Informatica can be
- An organization migrating from existing legacy system like mainframe to a new database system. So the migration of its existing data into a system can be performed.
- Enterprises setting up their Data Warehouse would require an ETL tool to move data from the Production system to Warehouse.
- Integration of data from various heterogeneous systems like multiple databases and file-based systems can be done using Informatica.
- Informatica can be used as a data cleansing tool.
Informatica is better than its competitors as it offers a wide range of product editions. So the user can opt for a specific edition based upon the requirement. Informatica is constantly featured as Data Integration product leader in the Gartner Magic Quadrant listing.
Below are the answer of the Trend Technology Informatica L1 Mock Test.
1) Which of the following services will not be created by admin
a) Application Service
b) core
c) Repository Service
Answer: core
2) Which of the following can be the target instance?
a) Relational
b) Relational, FlatFile and XML
c) OLL
Answer: Relational, FlatFile and XML
3) Which service reads mapping and session from the repository
a) Integration service
Answer: Integration service
4) In Workflow monitor, what are all the components you can view?
a) Session, Command, Workflow
b) Session, Command, Workflow, repository
c) Session, Command, Workflow, repository, Folders
Answer: Session, Command, Workflow
5) Flatfile cannot be used for
a) Source
b) Lookup
c) Aggregator
d) Target
Answer: Aggregator
6) Gantt Chart - Chronologic detail of logs
7) Logs can be viwed in
a) Text File
b) XML
c) Binary Code
d) All of the above
Answer: XML
8) Transformation that does not store cache file
Answer: Router
9) ___________ connects Integration service to metadata
a) Repository Service
b) Repository Manager
c) Metadata Manager
Answer: Repository Service
10) When a source is imported?
a) Data type/ Column name
b) Data type/ Column name/Key Constraint
c) Stored Procedure
d) Triggers
Answer: b) Data type/ Column name/Key Constraint
11) Chronological details of workflow
Answer: Gantt chart
12) Which transformation does not have variable port?
a) Expression
b) Rank
c) Filter
d) Aggregator
13) -sv means
Answer: Integration service name
14) Power Center domain means?
15) ________ is a set of instruction that extract, transforms and load data?
a) command
b) Session
c) Workflow
d)
Answer: Workflow
16) If the session fails, how will u identify the log?
a) log status
b) Error log code
c) log text files
d) All of the above
Answer: All of the above
17) Reusable components in mapping
a) Workflow
b) Mapplet
c) Transformation
d)
Answer: Mapplet
18) Set of instruction which transforms data from source to target
19) Flat Files - Fixed/Delimited
20) Which is not true about Sorter
Answer: It is passive
21) User defined events are possible?
a) Yes, with combination of event wait and event raise
b) Yes. On;y with workflow only
Answer: Yes, with combination of event wait and event raise
22) Source can be created
a) table
b) table,view
c) table,view,synonmyms
d) table,view, stored procedures
Answer: table,view,synonmyms
23) Target designer ways?
24) How to run the workflow using command?
Answer: PMCMD
25) GET_DATE_PART(Column 1,'HH')
If the column 1 is null, What is the result?
26) Once the source is dragged into mapping, it needs to be connected to?
a) SQ
b) Sorter
c) Agg
d) EXP
Answer: SQ
27) Workflow log contains?
a) Status of Session, Tasks and Worklet
b) Error occured and general information
c) None of the above
28) What is active transformation?
Answer: Changes in the number of rows
29) If the group by is not given in the Aggregator transformation, it will return
a) All the rows
b) One row
c) Error
Answer: One row
30) Shortcut can be used in which of the componets
a) Source definition
b) Reusable components
c) Mapplet
d) All of the above
Answer: Source definition (All of the above - Doubt)
31) Short cut can be used from
Answer: Shared Folder
32) You have to run a **** task but two different session. What is the best way?
a) Post SQL
b) Command task
c) Combination of events
Answer: Command Task
33) Tracing Levels
- Normal
- Verbose
- None
- ?
34) To see error logs to resolve it
a) use logvents
b) use Text Code
c) use Prefix
d) All of the above
Answer: Use logevents
35) Session invalid?
a) Adding table in the source databse
b) Adding Update/Joiner transformation
c) Deleting row from target table
d) Creating Index on source tables
Answer: Adding Update/Joiner transformation
36) Which provides row by row details about insert/update/delete?
Answer: Update Strategy
37) Control M - from BNC s/w
38) Target which cannot be used?
Answer: COBOL
39) Workflow monitor - Logs
40) Types of Tasks
a) Application Service
b) core
c) Repository Service
Answer: core
2) Which of the following can be the target instance?
a) Relational
b) Relational, FlatFile and XML
c) OLL
Answer: Relational, FlatFile and XML
3) Which service reads mapping and session from the repository
a) Integration service
Answer: Integration service
4) In Workflow monitor, what are all the components you can view?
a) Session, Command, Workflow
b) Session, Command, Workflow, repository
c) Session, Command, Workflow, repository, Folders
Answer: Session, Command, Workflow
5) Flatfile cannot be used for
a) Source
b) Lookup
c) Aggregator
d) Target
Answer: Aggregator
6) Gantt Chart - Chronologic detail of logs
7) Logs can be viwed in
a) Text File
b) XML
c) Binary Code
d) All of the above
Answer: XML
8) Transformation that does not store cache file
Answer: Router
9) ___________ connects Integration service to metadata
a) Repository Service
b) Repository Manager
c) Metadata Manager
Answer: Repository Service
10) When a source is imported?
a) Data type/ Column name
b) Data type/ Column name/Key Constraint
c) Stored Procedure
d) Triggers
Answer: b) Data type/ Column name/Key Constraint
11) Chronological details of workflow
Answer: Gantt chart
12) Which transformation does not have variable port?
a) Expression
b) Rank
c) Filter
d) Aggregator
13) -sv means
Answer: Integration service name
14) Power Center domain means?
15) ________ is a set of instruction that extract, transforms and load data?
a) command
b) Session
c) Workflow
d)
Answer: Workflow
16) If the session fails, how will u identify the log?
a) log status
b) Error log code
c) log text files
d) All of the above
Answer: All of the above
17) Reusable components in mapping
a) Workflow
b) Mapplet
c) Transformation
d)
Answer: Mapplet
18) Set of instruction which transforms data from source to target
19) Flat Files - Fixed/Delimited
20) Which is not true about Sorter
Answer: It is passive
21) User defined events are possible?
a) Yes, with combination of event wait and event raise
b) Yes. On;y with workflow only
Answer: Yes, with combination of event wait and event raise
22) Source can be created
a) table
b) table,view
c) table,view,synonmyms
d) table,view, stored procedures
Answer: table,view,synonmyms
23) Target designer ways?
24) How to run the workflow using command?
Answer: PMCMD
25) GET_DATE_PART(Column 1,'HH')
If the column 1 is null, What is the result?
26) Once the source is dragged into mapping, it needs to be connected to?
a) SQ
b) Sorter
c) Agg
d) EXP
Answer: SQ
27) Workflow log contains?
a) Status of Session, Tasks and Worklet
b) Error occured and general information
c) None of the above
28) What is active transformation?
Answer: Changes in the number of rows
29) If the group by is not given in the Aggregator transformation, it will return
a) All the rows
b) One row
c) Error
Answer: One row
30) Shortcut can be used in which of the componets
a) Source definition
b) Reusable components
c) Mapplet
d) All of the above
Answer: Source definition (All of the above - Doubt)
31) Short cut can be used from
Answer: Shared Folder
32) You have to run a **** task but two different session. What is the best way?
a) Post SQL
b) Command task
c) Combination of events
Answer: Command Task
33) Tracing Levels
- Normal
- Verbose
- None
- ?
34) To see error logs to resolve it
a) use logvents
b) use Text Code
c) use Prefix
d) All of the above
Answer: Use logevents
35) Session invalid?
a) Adding table in the source databse
b) Adding Update/Joiner transformation
c) Deleting row from target table
d) Creating Index on source tables
Answer: Adding Update/Joiner transformation
36) Which provides row by row details about insert/update/delete?
Answer: Update Strategy
37) Control M - from BNC s/w
38) Target which cannot be used?
Answer: COBOL
39) Workflow monitor - Logs
40) Types of Tasks
Below are the answer of the Informatica module of Trend.nxt learning.
No comments:
Post a Comment