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
- 18209 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
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How to convert multiple rows to single row (multiple columns) in informatica
Explain transaction control transformation in informatica
how to load rows into fact table in data warehouse
design of staging area?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How do you load only null records into target? Explain through mapping flow.
How we can create indexes after completing the load process?
What is sequence generator transformation in informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Describe the impact of several join conditions and join order in a joiner transformation?
Which transformation should we use to normalise the COBOL and relational sources?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What if the source is a flat-file?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
