Interested to Buy Any Domain ? << Click Here >> for more details...
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
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
is it possible to index the data in cache of lkp transformation ?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Difference between Target-based loading and constraint-based loading?
Define mapping and session?
What are the mapping parameters and mapping variables?
How do you use reject loader.
What is a shortcut and copy in Informatica and how two are different with each other?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Explain what are the different types of transformation available in informatica.
What is a router transformation?
What is a repository manager?
What is aggregate cache in aggregator transformation?
What is data caches/ index caches?
How we can use union transformation?
