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
- 17964 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / shafiq
1.SDLC(Software Developement Life Cycle)
It is a important concept for a developer
There are 7 Phases in SDLC
1.Prepration
2.Analysis
3.Design
4.Coding/Implementation
5.Testing/UAT
6.Deployment
7.Evaluation
2.Dimensions are nothing but context of measure on whch
facts are calculated,
facts are nothing but which contains all measurements of
business needs.
Conformed Dimension is used to join more than 2fact
table in multi star schema.
3.OLTP Maintains current data.
eg:ATM
| Is This Answer Correct ? | 2 Yes | 1 No |
What are the types of groups in Router transformation?
hw cn v elimate dublicate values from lookup without overriding sql?
Explain about HLD and LLD ?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
Briefly define a session task?
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
What are the methods for creating reusable transforamtions?
What is a standalone command task?
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
What are the different types of transformation available in informatica.
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
Teradata 
