Interested to Buy Any Domain ? << Click Here >> for more details...
Tell me about informatica architecture.
- 2 Answers
- 9521 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
difference between stop and abort
What are the types of caches in lookup? Explain them.
Differentiate between Load Manager and DTM?
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
Without using any transformations how u can load the data into target?
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
What are the different threads in DTM process?
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
How you can differentiate between connected lookup and unconnected lookup?
tell me about your project functionality
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
If there are more than one sessions running parallel in a worklet, which will be the last session ?
Teradata 
