Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of schemas?
- 11 Answers
- 87188 Views
- ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / giri
Schema is structure of information
1.STAR SCHEMA
-------------
Centralized Fact table connect the one or more denormalized data
2.SNOW FLAKE SCHEMA
-------------------
Centralized Fact table connect the one or more normalized data
3.STAR FLAKE SCHEMA
-------------------
One or more centralized fact table connect the single denormolized data
| Is This Answer Correct ? | 28 Yes | 23 No |
Post New Answer View All Answers
update strategy transformation in informatica
How to differentiate between the active and passive transformations?
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?
What is the maplet?
What is union transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
What are the reusable transformations?
Explain dynamic target flat file name generation in informatica
Differentiate between source qualifier and filter transformation?
explain about unit testing? in real time?
What are the components of Informatica? And what is the purpose of each?
Explain incremental aggregation in informatica
without table how to come first record only in oracle?
Informatica Checkpoints
How do you load unique records into one target table and duplicate records into a different target table?
