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
can we override a native sql query within informatica? How do we do it?
What is expression transformation?
Define update strategy?
What is the Rank index port in Rank transformation?
How to handle decimal places while importing a flatfile into informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How does a sorter cache works?
How do we call shell scripts from informatica?
whats the logic to load the lower level of granularity of data to fact table.
Define filter transformation?
Does an informatica transformation support only aggregate expressions?
What is a filter transformation and why it is an active one?
Why do you use Mapping Parameter and mapping variable?
How to differentiate between the active and passive transformations?
Enlist the various types of transformations.