Answer Posted / naresh_infa96
Domain : Informatica Domain is a collection or Group of Nodes and Services.
What is a Node ?
Node is a logical representation of physical Machine in a domain. In simple words a node is a computer in which we installed Informatica .
What is meant by Services : each Node in a domain runs two types of Services to perform the domain operations.
Types of Services : (a) Service Manager (b) Application Service
Service Manger : it is nothing but a service in windows , daemon in Unix. it runs the application services and performs the all domain operations
Application Service : a group of services that represnt server based functionality.
ex: Repository Service,Integration Service,Content Management Service,Model Repository Service,SQP BW service, Reporting Service
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to extract sap data using informatica?
can u any challenge your project?
Explain the types of lookup transformation?
What is flashback table ? Advance thanks
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain the shared cache and re-cache?
what are the deliverables?in your project?
Repository user profiles
What is meant by target load plan?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is rank index in rank transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is InformaticaPowerCenter?