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 / 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


Please Help Members By Posting Answers For Below Questions

Which development components of informatica have the highest usage?

605


What is the function of aggregator transformation?

589


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1648


Briefly explain the aggregator transformation?

612


Explain the different lookup methods used in informatica?

599






What is resilience time?

671


How to create the source and target database connections in server manager?

642


What do you understand by term role-playing dimension?

596


Define pmcmd command?

638


What are roles and groups and benefits of using them?

583


What are the reusable transformations?

708


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1065


What the difference is between a database, a data warehouse and a data mart?

603


What are the restrictions of union transformation?

589


What do you mean by channel change?

558