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
how tokens will generate?
Whats there in global repository
Explain how many types of dimensions are available in informatica?
What is a filter transformation?
What is olap (on-line analytical processing?
What is decode in informatica?
Could you explain what is enterprise data warehouse?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How do you convert single row from source into three rows into target?
According to his methodology what all you need before you build a datawarehouse
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?
Explain Dataware house architecture .how data flow from intial to end?
What is different between the data warehouse and data mart?
How to join three sources using joiner? Explain though mapping flow.
While migrating the data from one environment to another environment how would you manage the connections?