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
- 18112 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
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is the difference between Active and Passive transformation?
What are the different clients of powercenter?
How to use procedural logic inside infromatica?
What does “tail –f” command do and what is its use as an Informatica admin.
What are the features of complex mapping?
what is INFORMATICA TESTING process
Explain why we use partitioning the session in informatica?
Separate from a database, an information bazaar, and an information stockroom?
Explain the types of lookup transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How do you migrate data from one environment to another?
State the limitations where we cannot use joiner in the mapping pipeline?
According to his methodology what all you need before you build a datawarehouse
Tell me about MD5 functions in informatica
