what is the exact meaning of domain?
Answers were Sorted based on User's Feedback
Answer / sushil ramteke
The PowerCenter domain is the fundamental administrative
unit in PowerCenter. The domain supports the administration
of the distributed services. A domain is a collection of
nodes and services that you can group in folders based on
administration ownership.
| Is This Answer Correct ? | 24 Yes | 1 No |
Answer / deshmukh sachin
Hi , The Domain concept arises in Informatica version 8,
we have global integration service where in which we can
have domains and each domain can be configured to diffrent
environments, and each domain can be configured to have
diffrent nodes and we can assign a particular workflow to
run on different nodes , and Informatica corporation can
customize for particular node for better performance
and moreover if particaular workflow fails due to
connectivity problems , it automatically reassigns to
some other node which is avaialable
| Is This Answer Correct ? | 12 Yes | 6 No |
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 |
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
Can you use flat files in Mapplets.
generate date / time dimension in informatica
How to use procedural logic inside infromatica?
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
How to jion 2 tables, without using any condition?
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
What are teh different tasks that can be created in workflow manager?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
performance wise which one is better in joiner and lookup transformation
how can one come to know wether the records loak into the target if we use update strategy
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?