Tell me about informatica architecture.
- 2 Answers
- 8776 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
How mapping parameter and variable works
Can we override a native sql query within informatica?
How are indexes created after completing the load process?
Enlist the differences between database and data warehouse.
how to delete duplicate records by using filter transfermation?
How to add source flat file header into target file?
What is a configuration management?
what is difference between dimention table and fact table?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
how may sources can be used in a mapping at a time?(limit)
What are the challenges you have faced in your project?
How many number of sessions can one group in batches?
Teradata 
