1. What is mean by Domain?
Ans: Domain is a collection of nodes. Center of the Informatica Power center Infrastructure.
2. What is mean by node?
Ans: Node is the logical representation of a machine in a domain
3. How many types of nodes are there?
a) 1
b) 2
c) 3
d) 4
Ans: b - Gateway Node and Worker Node.
4. Gateway node is also called as?
a) Master Gateway
b) Worker Node
c) a & b
d) None of the above.
Ans: a
5. Where we need to register for getting the alerts In case of any failures of node or master gateway election process?
a) Domain
b) Integration Service
c) Node
d) Repository Service
Ans: c
6. Which tool can be used to get XML copies of Informatica objects?
a) Workflow Manager
b) Repository Manager
c) Workflow Monitor
d) Designer.
e) All of the above
f) a, b, d
Ans: f
7. Which tool can be used to create the folder at Informatica level?
a) Workflow Manager
b) Repository Manager
c) Workflow Monitor
d) Designer.
Ans: b
8. Email tasks and command tasks at reusable and non-reusable level can be migrated from one to other environment by using which tool?
a) Workflow Manager
b) Repository Manager
c) Workflow Monitor
d) Designer.
Ans: a
9. Admin console link will be in the following format?
a) http://servername:Port
b) http:\\ servername:Port
c) http::// servername::Port
d) None of The above
Ans: a
10. Access to the folders is given using the following?
a) Workflow Manager and Admin Console
b) Repository Manager and Admin Console
c) Workflow Monitor and Repository Manager
d) Designer.
Ans: b
11. Groups and Roles are created by using the following?
a) Workflow Manager
b) Repository Manager
c) Workflow Monitor
d) Designer.
e) Admin Console
Ans: e
12. Can we use Admin console to start/stop the services? Yes/no
Ans: Yes
13. User, Groups and roles creation is done in which tab under Admin console?
a) Security
b) Logs
c) Properties
d) None of the above
Ans: a
14. Folder creation and deletion can be done by?
a) Workflow Manager
b) Repository Manager
c) Workflow Monitor
d) Designer.
e) Admin Console
Ans: b
15. Killing locks on folders and objects can be identified in?
a) Workflow Manager
b) Repository Manager
c) Workflow Monitor
d) Designer.
e) Admin Console
Ans: e
16. What is the tool used to import the mappings?
a) Workflow Manager
b) Repository Manager
c) Workflow Monitor
d) Designer.
e) Admin console
Ans: d
17. Non-Reusable sessions can be migrated by using?
a) Workflow Manager
b) Repository Manager
c) Workflow Monitor
d) Designer.
Ans: a
18. What is the order needed to be followed while migrating the Informatica objects?
a) Mappings, workflows, mapplets, worklets and sessions
b) Mappings, mapplets, worklets, sessions and workflows
c) Workflows, mappings, worklets, sessions and mapplets
d) Mapplets, mappings, sessions, worklets, workflows
Ans: d
19. Can we convert a reusable session into no-reusable? Yes/No
Ans: No
20. What is the tool used to create connection object?
a) Workflow Manager
b) Repository Manager
c) Workflow Monitor
d) Designer.
Ans: a
21. Can we create the connections objects in QA and Prod environments? Yes/No
Ans: No
22. Where can we change the code page?
a) Session level
b) Mapping level
c) Connection object level
d) Workflow level.
Ans: C
23. Can we give access to a connection object to user who is not having access to the folder in which it is used? Yes/No
Ans: No
24. What is the tab used to provide the access to connection object?
a) Connection---> Edit
b) Connection---> Permissions
c) Connection---> copy as
d) Connection---> New
Ans: b
25. Integration service can be assigned/un-assigned to the following objects.
a) Mappings
b) Sessions
c) Worklets
d) Workflows
e) Folder
f) d and e
Ans: f
26. At any point of time a workflow can be assigned with multiple Integration services? Yes/No
Ans: No
27. If a reusable session part of a workflow needed to be deleted from workflow, can be delete from workflow level or task level?
Ans: Workflow level
28. Among the below listed objects which can be scheduled?
a) Command task
b) Email task
c) Workflow
d) Session
Ans: Workflow.
29. In how many ways we can schedule the workflows?
a) Reusable Schedulers
b) Non-Reusable Scheduler
c) a and b
d) None of the Above
Ans: c
30. Can we schedule a workflow from workflow monitor which is in Run On Demand? Yes /No
Ans: No
31. What should be the status of a workflow which is scheduled through cron job?
a) Un-scheduled
b) Run on Demand
c) Scheduled
d) None of the above
Ans: b
32. Can we schedule a workflow for specific no of runs? What are the options can be used?
a) Run Forever
b) End after____runs or End on (Date)
c) Run Continuously.
d) Run On Integration Service Initialization.
e) None of the Above.
Ans: Yes, End after____runs or End on (Date)
33. What is the tab used to edit the reusable schedulers in workflow manager?
a) Repository
b) Workflows
c) Versioning
d) Tools
Ans: b
34. Reusable schedulers can be created for folder level or repository level?
a) Folder level
b) Repository Level
c) Workflow Level.
d) None of the above.
Ans: a
35. A scheduled workflow will start by using the following process?
a) Repository Service
b) Integration service
c) Repository and Integration Service
d) None of the above
Ans: b
36. Sessions in the workflow are arranged in how many ways? What are they?
a) Series and Parallel
b) Series
c) Parallel
d) None of the Above.
Ans: a
37. What is the difference between ad-hoc load and scheduled load?
a) Ad-hoc load runs based on user request and mentioned date and time and Scheduled load runs as per the scheduled time
b) Ad-hoc load runs based on scheduled time and scheduled load runs based on user request and time
c) Both a and b
d) None of the above
Ans: a
38. What is a Repository and difference between repository database and repository service?
Ans: Repository is metadata which means it has data about the data (objects). It stores the data regarding the Informatica objects .For e.g.: We have a folder say “Folder1” and 3 mappings has been created within it, so all the information regarding all objects in mapping and the folder will be stored in repository database in forms of tables.
Repository database is a database which contains all the metadata whereas the repository service is nothing but a service which runs on repository database and provides its services.
OPB_Mapping: This table contains all the mapping names.
39. What is a code page?
Ans: Code page contains encoding to specify characters in a set of one or more languages.
e.g.: If you have Malaysian or Chinese character in your source data then you have to choose the appropriate code page for these characters else you’ll see square boxes once the data is loaded and processed as Informatica will not be able to understand those characters.
40. Pmrep and pmcmd command?
Ans: pmrep and pmcmd commands are the command line interface to perform Informatica related task. These command s are used most in form of scripts. Pmrep is used for all repository related tasks. Pmcmd is used for Informatica monitor and server related tasks
Eg: pmrep connect –r Repository_name –d Domain_name –n Username –x password
the above command connects to repository. Once connected you can create a folder in repository by below command
Pmrep createfolder –f Foldername –o OwnerName
Some of the pmcmd commands:
I. Startworkflow
II. Stopworkflow
III. Waitworkflow
IV. Recoverworkflow
V. Scheduleworkflow
VI. Startask
VII. Stoptask
41. How to start a workflow using pmcmd command?
Ans:
Pmcmd startworkflow [ folder]
[ taskInstancePath []]
[ paramfile]
[ localparamfile]
[ OSProfile] [-wait|-nowait]
[ runInsName] workflow
42. What is deployment group?
Ans: A deployment group is a global object that consists of versioned objects from one or more folders. You use a deployment group to copy the versioned objects to another folder or repository. You can use a deployment group when you want to copy some, but not all, of the objects in a folder. You can also use a deployment group to copy objects from multiple folders.
43. How would you join a node to the already existing domain?
Ans: Joining a node to an existing domain can be archived while installing Informatica.
e.g.: Server is on machine1 and the new node is on machine2. Then go to machine2-Open Installer->join node to domain while configuring domain and provide the existing domain details.
44. What is primary and backup node?
Ans: Primary node is a node where a current node or applications are running and backup node is defined to run the domain or application
45. Is it possible to create multiple domains on a single Informatica server?
Ans: Yes it is possible to create multiple nodes on same Informatica server.
46. What is a grid in Informatica?
Ans: Grid in Informatica is used for load balancing. A grid is nothing but a combination of nodes which distributes the request among them.
Eg: node1, node2, node3, node4 are assigned in a grid. 10 workflows started simultaneously. Now instead of giving burden to a single node to run the 10 workflows the request for running workflows will be distributed to all nodes.
47. Can we create Integration service without a Repository service and vice versa?
Ans: It is not possible to create an Integration service without a repository service however a repository can be created without an integration service.
48. Can we create multiple integration service on single repository?
Ans: Yes it is possible to create multiple integration service on single repository. This is used when you have to choose different code page for different integration service in same repository
Eg: Repository: ASIA_PACIFIC_Repo is used to load the data for countries specific to ASIA PACIFIC to target warehouse.
49. What is native users?
Ans: Native users are the users created with admin console.
50. What is meant by LDAP users?
Ans: LDAP users are the user which are configured with LDAP server (also may be MS Active directory) and LDAP is integrated with power center to allow users to provide single sign on.
51. What are roles and groups and benefits of using them?
Ans: Domain is a single point of entry or the administrative unit in Informatica. All the request from different clients (like Designer) first reaches to domain and then routed to associated services. A gateway node is the node on which a domain is defined.
52. What is resilience time?
Ans: Resilience time is the time defined in Informatica to wait before it lose the connection
on a network failure.
E.g.: If your resilience time is 180 sec and the network goes down so Informatica will wait for 180 sec and if network is established in between, the connection will be established. If the network is not up within 180 sec so the unsaved data will be lost and the client will be disconnected from the domain or repository
53. What are the services provided in informatica client tool?
a) Workflow Manager, Repository Manager, Workflow Monitor, Mapping Designer
b) Repository Designer, Mapping Monitor, Workflow Monitor, Workflow Manager
c) Both a and b
d) None of the above
Ans: a
54. What is the service used to run sessions and workflows?
a) Integration service
b) Repository service
c) Repository manager
d) Domain service
Ans: a
55. What is the service used to schedule workflows?
a) Workflow monitor
b) Workflow manager
c) Repository manager
d) Designer
Ans: Workflow manager
56. Creating a folder using pmrep command?
Ans: Pmrep createfolder –f Foldername –o OwnerName
I feel Informatica is the best and most useful tool to provide solutions to a large no.of complex database problems.
ReplyDeleteInformatica Read Soap API