Tell me about informatica architecture.

Answers were Sorted based on User's Feedback



Tell me about informatica architecture...

Answer / rajan raorane

Informatica describes about Extraction , Transfotrmation
and Loading
Extraction from OLTP database
Transfromation done on the exctracted Data
Load in DWH

OLTP-->ETL(informatica)-->DWH-->OLAP

Informatica 8.6 is inclusive of Repositary and Integrated
services
Repositary: Are used to create user and assign previliges
Integration Services: these are used to
1)create folders in Repositary Manger
2)design Mapping in Power Designer
4) Create Session and Work flow in Workflow designer
5) Status you can observe in Work flow monitor

Is This Answer Correct ?    3 Yes 2 No

Tell me about informatica architecture...

Answer / vemuri vijay

just tell about
client
and
services

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

Difference between Data and Index Caches?

0 Answers   Informatica,


In a sequential batch can you run the session if previous session fails?

4 Answers  


What is the difference between stop and abort in informatica

0 Answers   Informatica,


Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  


what is incremantal aggregation?

1 Answers  






In development project what is the process to follow for an etl developer from day1

0 Answers  


How can you complete unrcoverable sessions?

1 Answers  


What is meta data and system catalog?

2 Answers  


What is a sorter transformation?

0 Answers   Informatica,


how we can update a target table without update strategy and update override?

3 Answers   TCS,


What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,


How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,


Categories