1.what is SDLC of a project,explain in detail?
2.what are dimensions,facts?what is confirmed dimensions?
3.what is the need of OLTP? when we have datawarehousing?
Answer Posted / shafiq
1.SDLC(Software Developement Life Cycle)
It is a important concept for a developer
There are 7 Phases in SDLC
1.Prepration
2.Analysis
3.Design
4.Coding/Implementation
5.Testing/UAT
6.Deployment
7.Evaluation
2.Dimensions are nothing but context of measure on whch
facts are calculated,
facts are nothing but which contains all measurements of
business needs.
Conformed Dimension is used to join more than 2fact
table in multi star schema.
3.OLTP Maintains current data.
eg:ATM
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What do mean by local and global repository?
What are mapplets? How is it different from a Reusable Transformation?
What is DR strategy for Informatica project?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Why update strategy and union transformations are active?
What are session parameters ? How do you set them?
waht type of interface is used for testing the data in informatica
What are ETL Tools?
Repository user profiles
What are the performance considerations when working with aggregator transformation?
what are 3 tech challenges/ common issues you face?
What are the informatica performance improvement tips
Different qualification between a related rotate toward the sky and isolates look upward?
Why update strategy and union transformations are active? Explain with examples.
Define mapplet?