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
Explain the pipeline partition with real time example?
How to update source definition?
What are the different clients of powercenter?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
In informatica workflow manager, how many repositories can be created?
difference between repository database and repository service?
To import the flat file definition into the designer where should the flat file be placed?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is the benefit of session partitioning?
What is meant by pre and post session shell command?
can anyone suggest best free Talend data integration training online
How to start a workflow using pmcmd command?
What are the types of caches in lookup?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Do you find any difficulty while working with flat files as source and target?