Answer Posted / rr
Star schema has denormalised dimension tables connected to
a single fact table.
Snow flake schema has normalised dimension tables.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is domain and gateway node?
difference between repository database and repository service?
list out all the transformations which use cache?
How does a rank transform differ from aggregator transform functions max and min?
Tell me about Propagate functions in informatica
have u done any performance tuning? how u ll do?
In informatica workflow manager, how many repositories can be created?
Explain the code page compatibility?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the settings that you use to configure the joiner transformation?
wat are deployement groups in informatica, how it will be used for developers
In development project what is the process to follow for an etl developer from day1
Why filter transformation is an active one?
What is the use of an aggregator cache file?
What is decode in static cache?