Is snow flake or star schema used?
If star schema means why?
Answer Posted / senthil
hi
normally people using star schema in data warehousing
because it is de_normalized and easy way to retrieve data
from target and also understanding..
But snow flake is in fully normalized.normally OLTP
we use normalized ..
star schema used in data warehousing ..
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a stored procedure transformation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is data transformation manager process?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Explain the aggregator transformation?
Is there any way to read the ms excel datas directly into informatica?
What does refresh system mean, and what are its distinctive choice?
What are the differences between oltp and olap?
What is the difference between informatica 7.0 and 8.0?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How many ways are there to create ports?
How do you handle two sessions in Informatica
What is a repository manager?
What is the need for an etl tool?