in which situations do u go for starflake schema ?
Answer Posted / prabakaran
when we have single or multiple facts and not bothered
about query performance.
When we dont have disk storage limitations
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
How to handle decimal places while importing a flatfile into informatica?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Separate from an archive server and a powerhouse?
Different circumstance which drives informatica server to expel records?
Name the different lookup cache(s)?
How can you differentiate between powercenter and power map?
Make a note of the quantity vaults made in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How can we remove the duplicates from flat file source?
Under which circumstances, informatica server creates reject files?
How to load last n records of file into target table - informatica
What is deployment group?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Why update strategy and union transformations are active? Explain with examples.
Briefly explain the aggregator transformation?