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
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What you know about transaction control transformation?
What is standalone command task?
What is the function of aggregator transformation?
Define filter transformation?
wf dont have integration severances how you can run?
Define mapping and session?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What are the prerequisite tasks to achieve the session partition?
What is substr in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How will the document be delivered to me?
what is the hint? how to use it to reduce the query processing in program?
Repository user profiles