tell me the informatica architecture
Answer Posted / akhil4
infromatica product known as informatica power center.it consist of 3components
1.informatica power center client tools
in this we have
a.designer
b.repository manager
c.work flow manager
d.work flow monitor
2.informatica power center repository
3.informatica power center server
| Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
What is decode in informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How to differentiate between the active and passive transformations?
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 ?
What are the issues you have faced in your project? How did you overcome those issues?
Define joiner transformation?
generate date / time dimension in informatica
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Reusable transformation and shortcut differences
What is aggregate cache in aggregator transformation?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY