Tell me about informatica architecture.
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 |
Difference between Data and Index Caches?
In a sequential batch can you run the session if previous session fails?
What is the difference between stop and abort in 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
what is incremantal aggregation?
In development project what is the process to follow for an etl developer from day1
How can you complete unrcoverable sessions?
What is meta data and system catalog?
What is a sorter transformation?
how we can update a target table without update strategy and update override?
What is option by which we can run all the sessions in a batch simultaneously?
How to read data from flat file source if the data is in paragraph format?