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
- 17173 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 |
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
Is snow flake or star schema used? If star schema means why?
Explain the code page compatibility?
how we can update a target table without update strategy and update override?
How to load last n records of file into target table - informatica
Explain about the concept of mapping parameters and variables ?
Explain the tuning lookup transformation - informatica
How Union Transformation is an Active Trans?
What are the new features of the server manager in the informatica 5.0?
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
 Code page compatibly –Where all changes are made to handle the scenario.
Teradata 
