Most frequently Asked Informatica Interview Questions and Answers for freshers and experienced pdf free download
1. Can you copy the session to a different folder or repository?
Yes. By using copy session wizard, you can copy a session in a different folder or repository.
2. What is a command that used to run a batch?
pmcmd is used to start a batch.
3. What are the types of mapping in Getting Started Wizard?
Simple Pass through mapping
Slowly growing target mapping
4. What are the different types of Type2 slowly changing dimensions?
There are three types of slowly changing dimensions
SCD with versioning
SCD with flags
SCD with Date
5. What are the different threads in DTM process?
Master thread
Mapping thread
Reader thread
Writer thread
Pre and post session threads
6. What are the active and passive transformations?
An active transformation can change the number of rows that pass through it.
A passive transformation does not change the number of rows that pass through it.
7. What are the scheduling options to run a session?
Different options of scheduling are
Run only on demand: Informatica server runs the session only when user starts session explicitly
Run once: Informatica server runs the session only once at a specified date and time.
Run every: Informatica server runs the session at regular intervals as you configured.
Customized repeat: Informatica server runs the session at the date and time specified in the repeat dialog box.
8. How can we store previous session logs?
Just run the session in time stamp mode then automatically session log will not overwrite current session log.
9. What is the difference between Mapping and Mapplet?
Mapping is the collection of Source Definition, Target Definition, Transformation(s) and/or Mapplet.
Mapplet is a set of reusable transformations for applying same business logic.
10. What is the use of Repository Manager?
Repository Manager is used to manage folders, view Source/Target dependencies, Mapping Dependencies, adding and removing repositories, Versioning etc.
11. What are the various Tasks in Informatica Workflow Manager?
The various Tasks in Informatica are
Assignment Task
Command Task
Control Task
Decision Task
E-mail Task
Event Raise Task
Event Wait Task
Session Task
Timer Task
Link Task
12. What is the use of Source Analyzer?
Source Analyzer is used to create source definition.
13. What is the use of Target Designer?
Target Designer is used to create Target Definition.
14. What is Target Designer called prior to Informatica 8.6?
Warehouse Designer
15. Can we use Reusable Sequence Generator transformation in Mapplet?
No
16. Why Cache? Explain with an example?
If there are x lot number of records with y number of columns from source data and we need to extract z number of columns only (very less) then the cache stores those columns for respective records in the $PMCACHEDIR of Informatica Server so that we don’t need to extract each record from database and load into Informatica. Doing this increases the performance of the system.
17. What is the use of Shared Object?
It is easier to explain this using an example.
Suppose there is an object which is used by many users in the company.
If the object undergoes a change, this change has to be updated to each and every user. Instead, if the object is made as shared, then the update has to be done to the object and all other users get the update.
18. Difference between Informatica normal join and Oracle Equi join?
Equi join in Oracle is performed on oracle sources (relational sources) while Informatica Equi joins can be performed on non-relational sources too (oracle and flat file etc).
19. Can we install Power Center Informatica 8.X version on Windows 7?
No we can’t install Informatica on Power Center. We can Install Informatica 9.x on Windows 7.
20. What are the types of variables in Informatica?
There are three types of variables in Informatica
Predefined variable represented by $
User defined variable represented with $$
System variable denoted by $$$
More Informatic Interview Questions: Click Here
1. Can you copy the session to a different folder or repository?
Yes. By using copy session wizard, you can copy a session in a different folder or repository.
2. What is a command that used to run a batch?
pmcmd is used to start a batch.
3. What are the types of mapping in Getting Started Wizard?
Simple Pass through mapping
Slowly growing target mapping
4. What are the different types of Type2 slowly changing dimensions?
There are three types of slowly changing dimensions
SCD with versioning
SCD with flags
SCD with Date
5. What are the different threads in DTM process?
Master thread
Mapping thread
Reader thread
Writer thread
Pre and post session threads
6. What are the active and passive transformations?
An active transformation can change the number of rows that pass through it.
A passive transformation does not change the number of rows that pass through it.
7. What are the scheduling options to run a session?
Different options of scheduling are
Run only on demand: Informatica server runs the session only when user starts session explicitly
Run once: Informatica server runs the session only once at a specified date and time.
Run every: Informatica server runs the session at regular intervals as you configured.
Customized repeat: Informatica server runs the session at the date and time specified in the repeat dialog box.
8. How can we store previous session logs?
Just run the session in time stamp mode then automatically session log will not overwrite current session log.
9. What is the difference between Mapping and Mapplet?
Mapping is the collection of Source Definition, Target Definition, Transformation(s) and/or Mapplet.
Mapplet is a set of reusable transformations for applying same business logic.
10. What is the use of Repository Manager?
Repository Manager is used to manage folders, view Source/Target dependencies, Mapping Dependencies, adding and removing repositories, Versioning etc.
11. What are the various Tasks in Informatica Workflow Manager?
The various Tasks in Informatica are
Assignment Task
Command Task
Control Task
Decision Task
E-mail Task
Event Raise Task
Event Wait Task
Session Task
Timer Task
Link Task
12. What is the use of Source Analyzer?
Source Analyzer is used to create source definition.
13. What is the use of Target Designer?
Target Designer is used to create Target Definition.
14. What is Target Designer called prior to Informatica 8.6?
Warehouse Designer
15. Can we use Reusable Sequence Generator transformation in Mapplet?
No
16. Why Cache? Explain with an example?
If there are x lot number of records with y number of columns from source data and we need to extract z number of columns only (very less) then the cache stores those columns for respective records in the $PMCACHEDIR of Informatica Server so that we don’t need to extract each record from database and load into Informatica. Doing this increases the performance of the system.
17. What is the use of Shared Object?
It is easier to explain this using an example.
Suppose there is an object which is used by many users in the company.
If the object undergoes a change, this change has to be updated to each and every user. Instead, if the object is made as shared, then the update has to be done to the object and all other users get the update.
18. Difference between Informatica normal join and Oracle Equi join?
Equi join in Oracle is performed on oracle sources (relational sources) while Informatica Equi joins can be performed on non-relational sources too (oracle and flat file etc).
19. Can we install Power Center Informatica 8.X version on Windows 7?
No we can’t install Informatica on Power Center. We can Install Informatica 9.x on Windows 7.
20. What are the types of variables in Informatica?
There are three types of variables in Informatica
Predefined variable represented by $
User defined variable represented with $$
System variable denoted by $$$
More Informatic Interview Questions: Click Here
No comments:
Post a Comment