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 are the mapping parameters and mapping variables?
Define enterprise data warehousing?
Explain the types of transformations?
How can you increase the performance in joiner transformation?
What is a predefined event?
Differentiate between reusable transformation and mapplet.
How do you load alternate records into different tables through mapping flow?
What is dynamic cache?
How can we use mapping variables in informatica? Where do we use them?
What is dimensional table?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How to use pmcmd utility command?
What are active transformations.
How would you join a node to the already existing domain?
What are mapplets?