Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 18106 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / nagaraz
1.SDLC(SOFTWARE DEVLOPMENT LIFE CYCLE). THIS IS CYCLE SHOW
STEP OF HOW TO DEVELOPED APPLICATION/PROJECT .
STEP OF SDLC
1).MEETING THE CLIENT
2).REQUIRMENT
3).ANALYSIS/COLLECT INFORMATION.
4).CODING
5).TESTING
6).MAINTANENCE AND SUPPORT
2). Fact measure are additive values from the business (
OLTP) data, which are used to analyse the business by using
report generation.
Dimension measure are the non-additive ( text format)
values.Which are used to drill down reports.
3). OLTP MAINTAINS THE DATA FOR TRANSACTIONS, THESE ARE
DESIGNED FOR RECORDING DAILY OPERATOINS OF A BUSINESS.
| Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a connected look up and unconnected lookup?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Explain why we use partitioning the session in informatica?
Clarify the aggregator change?
Can you use flat files in Mapplets.
How does a rank transform differ from aggregator transform functions max and min?
can we override a native sql query within informatica? How do we do it?
What are data-driven sessions?
What is primary and backup node?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is informatica? Why do we need it?
How many input parameters can exist in an unconnected lookup?
What are the modules in Power Center
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Partition, what happens if the specified key range is shorter and longer
