Interested to Buy Any Domain ? << Click Here >> for more details...
Is snow flake or star schema used?
If star schema means why?
- 4 Answers
- 9277 Views
- CTS, Sonata, I also Faced
- E-Mail Answers
Answer Posted / radhakrishnansk
star schema is used for easy retrieval.
It is in 2nd normal form.
But snow flake is in 3rd normal form it needs more joins for
retrieval.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Where is metadata stored?
What is a sequence generator transformation?
Difference between Target-based loading and constraint-based loading?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Explain load alternative records / rows into multiple targets - informatica
Which version configuration tool used in ur project?
How we can create indexes after completing the load process?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How to differentiate between the active and passive transformations?
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??
What is informatica? Why do we need it?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
