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?

Answers were Sorted based on User's Feedback



1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimens..

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

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimens..

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

Post New Answer

More Informatica Interview Questions

What are the different ways to implement parallel processing in informatica?

0 Answers  


what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,


is it possible to index the data in cache of lkp transformation ?

0 Answers  


What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  


how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,






what is service oriented architecture in Informatica 8 version

1 Answers   Cap Gemini, IBM, Systech, TCS,


my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,


what is mystery dimension?

1 Answers  


If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  


How to load data in informatica ?

0 Answers  


I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  


Where should yoU place the flat file to import the flat file defintion to the designer?

4 Answers  


Categories