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
Write the unconnected lookup syntax?
Clarify the aggregator change?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is the use of source qualifier?
is it possible to index the data in cache of lkp transformation ?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What are the new features of informatica 9.x developer?
Explain lookup transformation in informatica
What is the way to execute pl/sql script using informatica mapping?
Quickly characterize reusable change?
What is union transformation in informatica?
Parameter and variable differences
