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

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7893


What is workflow monitor?

695


What is a sorter transformation?

782


What is the difference between stop and abort in informatica

760


Explain the code page compatibility?

731






I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1302


How you know when to use a static cache and dynamic cache in lookup transformation?

1425


How might one distinguish in the case of mapping is right or not without associating session?

733


What is aggregator transformation in informatica?

629


Under what condition selecting sorted input in aggregator may fail the session?

750


To import the flat file definition into the designer where should the flat file be placed?

748


Which version configuration tool used in ur project?

2864


What are the tuning techniques you applied during your last project

1661


can you please explain me pre session and post session options?

6623


What is option by which we can run all the sessions in a batch simultaneously?

759