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
- 18104 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Performance tuning( what you did in performance tuning)
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is rank transformation in informatica
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How do you set a varible in incremental aggregation
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
In development project what is the process to follow for an etl developer from day1
Explain the different dimensions.
what is the Default Source Option For Update Strategy Transformation?
How to Create a folder using pmrep command?
what is diff b/t sorter t/r and agg have the option sorter property...
have u done any performance tuning? how u ll do?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is meant by incremental aggregation?
