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
Where are the source flat files kept before running the session?
Enlist the advantages of informatica.
What is intricate mapping?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How can we update a record in the target table without using update strategy?
What you know about transaction control transformation?
Can we create multiple integration service on single repository?
What is an expression transformation in informatica?
What are the different ways to implement parallel processing in informatica?
What is a sequence generator transformation?
How would you join a node to the already existing domain?
Parameter and variable differences
Is stop and abort are same in informatica?
What does “tail –f” command do and what is its use as an Informatica admin.
Mention a few design and development best practices for informatica?
