Answer Posted / 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 |
Post New Answer View All Answers
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the types of schemas we have in data warehouse and what are the difference between them?
What is the benefit of session partitioning?
What is the surrogate key?
What is the use of code page?
what are the deliverables?in your project?
What is the Process to creating lookup transformation in informatica
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How to do unit testing in informatica? How to load data in informatica ?
Explain about cumulative Sum or moving sum?
What is exclusive and normal mode for repository services?
expain about the tune parameters?
can you please explain me pre session and post session options?
What are the main issues while working with flat files as source and as targets ?
