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
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is workflow monitor?
What is a sorter transformation?
What is the difference between stop and abort in informatica
Explain the code page compatibility?
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.
How you know when to use a static cache and dynamic cache in lookup transformation?
How might one distinguish in the case of mapping is right or not without associating session?
What is aggregator transformation in informatica?
Under what condition selecting sorted input in aggregator may fail the session?
To import the flat file definition into the designer where should the flat file be placed?
Which version configuration tool used in ur project?
What are the tuning techniques you applied during your last project
can you please explain me pre session and post session options?
What is option by which we can run all the sessions in a batch simultaneously?