Interested to Buy Any Domain ? << Click Here >> for more details...
in which situations do u go for snowflake schema ?
- 2 Answers
- 8515 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bala
If suppose we are having the multiple Fact tables and
multiple dimension tables normalized data ; we can go for
snowflake schema.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / giri
it will used at time u will maitain normalised data u r
data having more cordinality dat tables
| Is This Answer Correct ? | 0 Yes | 0 No |
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
How can we use batches?
Enlist the differences between database and data warehouse.
If we are using an aggregator but forget to mention the group by port .what will be the output??
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to call shell scripts from informatica?
What are mapplets? How is it different from a Reusable Transformation?
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
explain abt union t/r?
How does the server recognize the source and target databases. Elaborate on this.
Teradata 
