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
- 18208 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 a rank transform?
How to delete duplicate row using informatica?
Enlist the advantages of informatica.
What is informatica? Why do we need it?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Which files are created during the session rums by informatics server?
what is the hint? how to use it to reduce the query processing in program?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Enlist few areas or real-time situations where informatica is required.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How are indexes created after completing the load process?
What are the new features of informatica 9.x in developer level?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is informatica metadata and where is it stored?
Enlist some properties of sessions.
